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

¦p¦óÅýEXCEL¤À¿ì©Î­pºâ¥X¦P¤@Ä椺ªº´X­Ó¼Æ­È

¦^´_ 10# samwang

TEXT( value, format_text)

format_text = "¥¿;­t;¹s;¤å¦r"

[<>] ªí¥Ü¹s¥H¥~©Ò¦³¼Æ¦r

!«á­±ªº¦r¬°±j­¢©ÊÅã¥Ü

"[<>];!0;!0;!0" ªí¥ÜÅã¥Ü¹s¥H¥~©Ò¦³¼Æ¦r¡A¨ä¥L 0¤Î¤å¦r³¡¤À¥H !0 ±j­¢Åã¥Ü¬° 0
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089
ÁÂÁª©¥D«ü¾É¡A

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD