如何在 Excel 中生成从 00.0000 到 99.9999 的序列号?
例如
00.0000
01.0001
01.0002
----
99.9999
更新
Sub test()
[A1:A100000000] = [index((row(1:10000000)-1)/100000,)]
[A1:A100000000].NumberFormat = "00.000000"
End Sub
答案1
对于vba:
Sub test()
[A1:A1000000] = [index((row(1:1000000)-1)/10000,)]
[A1:A1000000].NumberFormat = "00.0000"
End Sub