ML089

¦^´_  ML089
·PÁÂML089ª©¥D²¤Æ¤½¦¡
½Ð°Ý¡G¦b=SUBSTITUTE(TEXT(A1,"[DBNum2]0.00;;"),".","ÂI") ¤¤¨Ï¥Î¬õ ...
p212 µoªí©ó 2013-12-10 22:14

TEXT(¼Æ¦r¡A"¥¿;­t;¹s;¤å¦r")
«á­±±N¨â­Ó ;; ¥D­n§@¥Î¬O¨S¦³¿é¤J¼Æ­È®É¥HªÅ¥Õ§e²{

p212

¦^´_ 5# ML089
·PÁÂML089ª©¥D²¤Æ¤½¦¡
½Ð°Ý¡G¦b=SUBSTITUTE(TEXT(A1,"[DBNum2]0.00;;"),".","ÂI") ¤¤¨Ï¥Î¬õ¦r³¡¥÷¡u2­Ó¤À¸¹¡v¥Î·N¦ó¦b¡H
·Ð½Ð½ç±Ð¡AÁÂÁ¡I

ML089

=SUBSTITUTE(TEXT(A1,"[DBNum2]0.00;;"),".","ÂI")

p212

¦^´_ 1# sasah168
Sorry!
3#ªº¦^ÂÐ¥¼©P¥þ¡A½Ð°Ñ¦Ò¤U¦C²Õ¦X¤½¦¡¡C
°²³]Àx®æA1¬°180.30¡A¥ô¤@Àx¦s®æ¿é¤J
=LEFT(TEXT(A1,"[DBNum2]0.00"),FIND(".",TEXT(A1,"[DBNum2]0.00"))-1)&"ÂI"&RIGHT(TEXT(A1,"[DBNum2]0.00"),LEN(TEXT(A1,"[DBNum2]0.00"))-FIND(".",TEXT(A1,"[DBNum2]0.00")))
µª®×§Y¬°¡u³ü®Ã¹sÂI°Ñ¹s¡v
«ä¸ô¡G¥ô¤@Àx¦s®æ¿é¤J=TEXT(A1,"[DBNum2]0.00")±o¡u³ü®Ã¹s.°Ñ¹s¡v
¤p¼Æ©T©w¨â¦ì¥i¬Ù²¤¦¨......&"ÂI"&RIGHT(TEXT(A1,"[DBNum2]0.00"),2)

p212

¦^´_ 1# sasah168
°²³]Àx®æA1¬°180.3
©ó¥ô¤@Àx¦s®æ¿é¤J =LEFT(TEXT(A1,"[dbnum2]"),FIND(".",TEXT(A1,"[dbnum2]"))-1)&"ÂI"&RIGHT(TEXT(A1,"[dbnum2]"),LEN(TEXT(A1,"[dbnum2]"))-FIND(".",TEXT(A1,"[dbnum2]")))

softsadwind

¦^´_ 1# sasah168


    https://dl.dropboxusercontent.com/u/61135474/%E8%8B%B1%E6%96%87%E5%A4%A7%E5%AF%AB%E8%BD%89%E6%8F%9B.xls
°Ñ¦Ò¬Ý¬Ý....