小写转换大写:10200元,求公式可以转换为:壹万零仟贰佰零拾零元零角...答:这是在会计人论坛里找的,你看看能不能用,他们都 说好用 =IF(A1<0,"负","")&SUBSTITUTE(TEXT(TRUNC(ROUND(A1,2)),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".",ROUND(A1,2))),TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]")&IF(ISNUMBER(FIND(".0",ROUND(A1,2))),...