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

¸Ñ¨M1004¥N½X

¸Ñ¨M1004¥N½X

¦U¦ì¤j¤j:

§Ú¼g¤F¤@­Ó²³æªºµ{¦¡µ¹°ê¤º¦P¨Æ¨Ï¥Î, ¦ý¦b§Úªº¹q¸£¤W°õ¦æ¬O¨S¦³°ÝÃD, ¦ý·í¥L­Ì¨Ï¥Î,®É, ´N·|¥X²{¥N½X"1004" ¥X²{¦b
"Range("H:H").NumberFormatLocal = "#,##0.00;[RED]#,##0.00;-;""

½Ð°Ý¦U¦ì¤j¯«,§Ú¿ù¦b¨º¤@­Ó¦a¤è©O??

ÁÂÁÂ

20190331®w¦sªí (­×§ï).rar (172.75 KB)

»y¨¥¨t²Î¤£¤@­P, §ï¦¨¦¨[¬õ¥]]¸Õ¸Õ

TOP

¦^´_ 1# mdr0465
¤¤¤å¨t²Î®É¥Î NumberFormatLocal ­n§ï¬°
Range("H:H").NumberFormatLocal = "#,##0.00;[¬õ¦â]#,##0.00;-;"

©ÎªÌ§A¥i¥H¥Î
Range("H:H").NumberFormat = "#,##0.00;[RED]#,##0.00;-;"
´N¤£¨ü»y¨¥¼vÅT
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C

TOP

¦^´_ 2# ikboy


ÁÂÁ®v¥S, ¨ü±Ð¤F

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD