Hi, How to auto-fill 0001.HK to 8000.HK in Excel?

💻 軟件台軟體

[匿名]

2017-02-13 5:57 pm

回答 (1)

Cheng

2017-02-15 8:49 pm

A1=TEXT(ROW(),"0000")&".HK"
下拉到8000

巨集Macro
Sub test()
For i = 1 To 8000
Cells(i, 1) = Format(i, "0000") & ".HK"
Next
End Sub

👍 0 👎 0