ããæ¹æ³ä¸ãå¨A1åå æ ¼è¾å ¥æ°åï¼B1åå æ ¼è¾å ¥â=SUBSTITUTE(SUBSTITUTE(IF(ISNUMBER(FIND(".",A1)),TEXT(LEFT(A1,FIND(".",A1)-1),"[dbnum2]")&"å "&TEXT(MID(A1,FIND(".",A1)+1,1),"[dbnum2]")&"è§"&TEXT(MID(A1,FIND(".",A1)+2,1),"[dbnum2]")&"å",TEXT(A1,"[dbnum2]")&"å æ´"),"è§å","è§æ´"),"-","è´")âï¼å车å³å¯ã
ããæ¹æ³äºãå¨A1åå æ ¼è¾å ¥æ°åï¼B1åå æ ¼è¾å ¥â=IF(A2<0,"è´","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"å "&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A2,"0.00"))),"è§","")&IF(LEFT(RIGHT(ROUND(A2,2),3))=".",TEXT(RIGHT(ROUND(A2,2)),"[DBNum2]")&"å","æ´")âï¼å车
ãã