在EXCEL中如何讲数字转换成汉字货币格式dbuam急

如题所述

举报该文章

第1个回答 2009-05-06

=IF((A7-INT(A7))=0,TEXT(A7,"[DBNUM2]")&"元整",IF(INT(A7*10)-A7*10=0,TEXT(INT(A7),"[DBNUM2]")&"元"&TEXT((INT(A7*10)-INT(A7)*10),"[DBNUM2]")&"角整",TEXT(INT(A7),"[DBNUM2]")&"元"&IF(INT(A7*10)-INT(A7)*10=0,"零",TEXT(INT(A7*10)-INT(A7)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(A7,1),"[DBNUM2]")&"分"))

第2个回答 2009-05-06

=IF(ISNUMBER(A1),IF(INT(A1),TEXT(INT(A1),"[dbnum2]")&"元",)&IF(INT(A1*10)-INT(A1)*10,TEXT(INT(A1*10)-INT(A1)*10,"[dbnum2]")&"角",IF(INT(A1)=A1,,IF(A1<0.1,,"零")))&IF(ROUND((A1)*100-INT(A1*10)*10,),TEXT(ROUND(A1*100-INT(A1*10)*10,),"[dbnum2]")&"分。","整"),"")

第3个回答 2009-05-06

格式--单元格式--数字--会计专用。本回答被网友采纳

第4个回答 2009-05-06

右键--单元格格式--特殊--中文大写数字

Warning: Invalid argument supplied for foreach() in /www/wwwroot/aolonic.com/skin/templets/default/contents.html on line 45