word2007里如何将人民币小写变大写
发布网友
共3个回答
热心网友
插入-编号-选择大写-在输入框内输入数字
只限整数啊
热心网友
=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为你需要转换的单元格
热心网友
插入里面有一个编号，用哪个就行了。
