- ©«¤l
- 830
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 910
- ÂI¦W
- 4
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2024-9-6
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2015-5-17 21:38 ½s¿è
¦U¦ì«e½ú, ½Ð±Ð¤@Ó°ÝÃD
§Ú¥ÎExcel VBAªºQueryTables.Add ¶×¤Jºô¶¸ê®Æ, µ²ªG¼Æ¦r«e±ªº"0"³£³Q¥h°£¤F,
...
Jackie_1st µoªí©ó 2015-5-17 03:23 ![](https://forum.twbts.com/images/common/back.gif)
¦b½áÈ«ü¥Oªº«e±¹ï±ý½áȪºÀx¦s®æ¥[¤W :
.NumberFormat = "@"
¤§«á¦A½áȮɼƦr«e±ªº0´N¤£·|³Q²M±¼¤F,
n¯d·N¨Ï¥Î¦¹ªk«áÀx¦s®æ¤º®e¬°¤å¦r«¬ºA.
¥t¤@Ó¤èªk¬O¦b ½áÈ ªº¤º®e«e±¥[¤W '
¨Ò¦p 00086 §ï¦¨ '00086
¤£¹L¤§«á¨úÈ®Én¯d·N ' ªº³B²z.
ÁÙ¦³ Excel VBA ¬ÛÃö°Q½×À³¸Ónµoªí¦b :
Excelµ{¦¡°Ï
¤º³á. |
|