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

Åã¥Ü³f¹ô

Åã¥Ü³f¹ô

¦U¦ì¤j¤j¡G
¦³­Ó°ÝÃD·Q§â¼Æ¦rÅܦ¨¬üª÷
A1            B1
12.55       ³ü¬B¶L¤¸¥î¨¤¥î¤À¾ã
­n¦p¦ó¼g©O¡H
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

ÁÂÁÂH¤j¤jªº¸Ñ´b¡A¤w¸g§¹¥þ¥¿¸Ñ
¬O¥¿¸Ñ¡A¤£¬OÉøѮ@
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

=IF(A1=0,"",TEXT(INT(A1),"[DBNum2]G/³q¥Î®æ¦¡¤¸")&IF(A1-INT(A1)=0,"",TEXT((A1-INT(A1))*100,"[DBNum2]0¨¤0¤À"))&"¥¿")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh&jackdreamªº¦^ÂÐ
¨ÌH¤j¤½¦¡¨Ó»¡¡A¦pªG23ªº¸Ü¡A·|¥X²{"°Ñ¬B°Ñ¤¸¹s¨¤¹s¤À¤¸"¡A¨S¦³¤p¼ÆÂI¡AÀ³¸Ó¬O¤£¥Î¹s¨¤¹s¤À
¨Ì¯«©_J¨Ó»¡´£¨Ñªº¨Ó»¡¡A¦pªG¬O33.33¡A·|¥X²{"°Ñ¬B°Ñ¤¸°Ñ¬B°Ñ¤À¾ã"¡AÀ³¸Ó¬O­n°Ñ¨¤°Ñ¤À
³o­Ó­n¦p¦ó­×§ï¡A½Ð¤j¤j«üÂI«üÂI
¤p§Ì¬Oexcelµ{¦¡ªì¾ÇªÌ¡A½Ð¦h¦h«ü±Ð

TOP

¦^´_ 1# chiahuo

½Ð°Ñ¦Ò http://gb.twbts.com/index.php?topic=1744.0

TOP

=TEXT(INT(A1),"[DBNum2]G/³q¥Î®æ¦¡¤¸")&TEXT((A1-INT(A1))*100,"[DBNum2]0¨¤0¤À")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD