ªð¦^¦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¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD