例如:在A1单元格中输入32.3,在A2单元格中显示叁拾贰元叁拾美分
Excel:人民币小写金额转换大写技巧两则
http://www.achot.com/Article/25/Article_20345_1.html
自学吧,灵活运用,下面是我改好的
A2=IF(A1<0,"金额为负无效",
(IF(OR(A1=0,A1=""),"零美元",
IF(A1<1,"",
TEXT(INT(A1),"[dbnum2]G/通用格式")&"美元"))))&
IF(
(INT(A1*100)-INT(A1)*100)=0,"整",
TEXT((INT(A1*100)-INT(A1)*100),"[dbnum2]")&"美分")
http://www.achot.com/Article/25/Article_20345_1.html
自学吧,灵活运用,下面是我改好的
A2=IF(A1<0,"金额为负无效",
(IF(OR(A1=0,A1=""),"零美元",
IF(A1<1,"",
TEXT(INT(A1),"[dbnum2]G/通用格式")&"美元"))))&
IF(
(INT(A1*100)-INT(A1)*100)=0,"整",
TEXT((INT(A1*100)-INT(A1)*100),"[dbnum2]")&"美分")
温馨提示:答案为网友推荐,仅供参考