- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
1.§ï¥Î°}¦C¿é¤J¡AÀþ¶¡§¹¦¨
Dim i&,rng
rng = Range(Cells(4, 1), Cells(65536, 1))
For i = 1 To UBound(rng)
rng(i, 1) = VBA.Format$(Trim(rng(i, 1)), "'" & "00000000")
Next
Cells(4, 1).Resize(UBound(rng)) = rng
2.¤W¶Ç§Aªº¤å¥ó¤~·|ª¾¹D¿z¿ï¤°»ò |
|