ªð¦^¦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 : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD