excel 數(shù)字小寫轉(zhuǎn)大寫的函數(shù)公式
比如 a1單元格中的數(shù)字：1203002.02 在f17中 轉(zhuǎn)換為 壹佰貳拾萬零叁仟零貳元零貳分
我現(xiàn)有的公式 =IF(F17=0,"",(TEXT(ROUNDDOWN(F17,0),"[DBNum2]")&"元"&IF(ROUNDDOWN(F17,0)=F17,"整",IF(ROUNDDOWN(F17*10,0)=F17*10,TEXT(RIGHT(F17*10,1),"[DBNum2]")&"角整",IF(ROUNDDOWN(F17*10,0)=ROUNDDOWN(F17,0)*10,"零"&TEXT(RIGHT(F17*100,1),"[DBNum2]")&"分",TEXT(RIGHT(ROUNDDOWN(F17*10,0),1),"[DBNum2]")&"角"&TEXT(RIGHT(F17*100,1),"[DBNum2]")&"分")))))
只能轉(zhuǎn)成 壹佰貳拾萬叁仟零貳元零貳分