我原来的长代码如下:
dim C as String
Select Case B
Case 1 To 9
C = "00000000" & A
Case 10 To 99
C = "0000000" & A
Case 100 To 999
C = "000000" & A
Case 1000 To 9999
C = "000000" & A
Case 10000 To 99999
C = "00000" & A
Case 100000 To 999999
C = "0000" & A
Case 1000000 To 9999999
C = "000" & A
Case 10000000 To 99999999
C = "00" & A
Case 100000000 To 999999999
C = "0" & A
Case 1000000000 To 9999999999
C = A
End Select
如果不涉及数据库,你的长代码可以用format搞定吧?
Dim A, C
A = 123222
C = Format(A, "0000000000")
Debug.Print C
------------------------------------------------
当然涉及数据库,Format不适用.
如果Format可以的话,我也不用想破头去想出那么长一段代码出来了.
如果早点知道Right函数的这个小技巧,这段长代码也不存在了.