excel数字小写转大写的函数公式
比如a1单元格中的数字:1203002.02在f17中转换为壹佰贰拾万零叁仟零贰元零贰分
我现有的公式=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]")&"分")))))
只能转成壹佰贰拾万叁仟零贰元零贰分
邮箱:联系方式: