§âExcel ¸ê®Æ¶×¥X¬°¯Â¤å¦r ¨Ã¶ñ¤J©T©wÈ
- ©«¤l
- 14
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 64
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-11-3
- ³Ì«áµn¿ý
- 2017-5-30
|
§âExcel ¸ê®Æ¶×¥X¬°¯Â¤å¦r ¨Ã¶ñ¤J©T©wÈ
½Ð°Ý §Ú¦³¤@±iexcelªí
ªíÃþ ªÑ²¼¥N½X ¦~¥÷ ¼Æ¦rA ¼Æ¦rB
A01 6271 96 55.6 0.27
ªÑ²¼¥N¸¹ «e±¸É4Ó0
¦~¤À «á±¸É3Ó0
¼Æ¦rA «e±¸É4Ó0(¤]´N¬O¤p¼ÆÂI«en¦³8½X),¨ú¨ì¤p¼Æ²Ä¤T¦ì,¥B¤p¼ÆÂI¤£n->000055600
¼Æ¦rB ¦P«e --> 000000270
³Ì«áµ²ªG-->A010000627196000000055600000000270
§Ú·Qn¦A©T©wªº®æ¤l¶ë¤J©T©wªºÈ ¨Ã²£¥X¦¨txtÀÉ~
½Ð°ÝVBAn«ç»ò¤~¯à°µ¨ì
§Ú·|²£¥XTXTÀÉ~~¦ý§Ú¥d¦A¶ë¤J©T©wÈ
©Î¬O¤£¥ÎVBA¤]¥i¥H ¦³¬Æ»ò¨ç¼Æ¥i¥H¹F¨ì³oºØ¥\®Ä¹À??
½Ð¦U¦ì¤j®vÀ°¦£~ÁÂÁ |
-
-
DATA.zip
(7.1 KB)
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¥»©«³Ì«á¥Ñ stillfish00 ©ó 2015-2-3 16:37 ½s¿è
¦^´_ 1# zero1019
¦pªGn¸É¹sªº³£¬O¼Æ¦r¥i¥H¥Îformat¨ç¼Æ´N¦n¡A¦pªGÁÙ¥]§t¦r¥À¡A¥i¥H¦Û¤v¼g...- Function FillStrZero(strIn As String, digit As Integer, Optional fromLeft As Boolean = True) As String
- If Len(strIn) > digit Then Err.Raise vbObjectError + 9999, , "String length should not larger than " & digit & "digit."
- FillStrZero = IIf(fromLeft, String(digit - Len(strIn), "0") & strIn, strIn & String(digit - Len(strIn), "0"))
- End Function
½Æ»s¥N½X test- Sub Test()
- MsgBox [A2] & FillStrZero([B2], 8) & FillStrZero([C2], 5, False) & FillStrZero(Round([D2] * 1000), 9) & FillStrZero(Round([E2] * 1000), 9)
- End Sub
½Æ»s¥N½X |
|
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
|
|
|
|
|
- ©«¤l
- 45
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-1-18
- ³Ì«áµn¿ý
- 2015-10-9
|
¦^´_ 1# zero1019 - =A2&TEXT(B2,REPT("0",8))&C2*1000&TEXT(D2*1000,REPT("0",9))&TEXT(E2*1000,REPT("0",9))
½Æ»s¥N½X |
|
|
|
|
|
|