excel金额大小写转换.doc

文档介绍：excel金额大小写转换
D
角"&TEXT(INT(F4*100)-INT(F4*10)*10,"[DBNum2]G/通用格式")&"分")),TEXT(INT(F4),"[DBNum2]G/通用格式"&"元")&IF((INT(F4*10)-INT(F4)*10)=0,IF((INT(F4*100)-INT(F4*10)*10)=0,"","零"),IF((INT(F4*)-INT(F4)*)=0,"零","")&TEXT(INT(F4*10)-INT(F4)*10,"[DBNum2]G/通用格式")&"角")&IF((INT(F4*100)-INT(F4*10)*10)=0,"整",TEXT(INT(F4*100)-INT(F4*10)*10,"[DBNum2]G/通用格式")&"分
=IF(ROUND(O23,2)<0,"无效数值",IF(ROUND(O23,2)=0,"零",IF(ROUND(O23,2)<1,"",TEXT(INT(ROUND(O23,2)),"[dbnum2]")&"元")&IF(INT(ROUND(O23,2)*10)-INT(ROUND(O23,2))*10=0,IF(INT(ROUND(O23,2))*(INT(ROUND(O23,2)*100)-INT(ROUND(O23,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(O23,2)*10)-INT(ROUND(O23,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(O23,2)*100)-INT(ROUND(O23,2)*10)*10)=0,"整",TEXT((INT(ROUND(O23,2)*100)-INT(ROUND(O23,2)*10)*10),"[dbnum2]")&"分")))
O23为你需要转换的单元格
Word：插入-编号-选择大写-在输入框内输入数字
只限整数啊