ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

VBA Àx¦s®æ内ªº®æ¦¡ªº¼Æ­ÈÂà¦^¯u¥¿ªº¼Æ­È

VBA Àx¦s®æ内ªº®æ¦¡ªº¼Æ­ÈÂà¦^¯u¥¿ªº¼Æ­È


½Ð°Ý·Q±N¤å¦rÄæGÀx¦s®æ内ªº®æ¦¡ªº¼Æ­ÈÂà¦^¯u¥¿ªº¼Æ­È¡A¦pªG¥ÎVBA ºt¥Ü

¦^´_ 1# 198188

[G:G].NumberFormatLocal = "0_ "
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 2# Andy2483

ÁÂÁ¡I­è­è¬ã¨s¨ì³o­Ó¡C
Columns("G:G").Select
Selection.NumberFormatLocal = "GENERAL"
Selection.Value = Selection.Value

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD