Q1：excel表格里小写数字怎么转换成大写金额
给你编个公式吧
=IF(A2<0,"负","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A2,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A2,2),3))=".",TEXT(RIGHT(ROUND(A2,2)),"[DBNum2]")&"分","整")
其中"A2"是数字格,即需要转换为大写的那格。wwW.BazHIShI.CO☆M
Q2：在电子表格小写金额怎样自动转换成大写金额
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ROUND(A1,2)),"[dbnum2]")& "元" & TEXT(MOD(ROUND(A1,2),1)*100,"[dbnum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零")
Q3：excel表格中如何将小写金额转换为大写金额，如数值为0时则不在表中显示，如数值为负时则显示“负***”
=IF(H12=0,"",IF(INT(H12),TEXT(TRUNC(H12),"[dbnum2]")&"元","")&IF(MOD(H12,1)=0,"整",IF(TRUNC(H12,1),IF(H12=TRUNC(H12,1),TEXT(LEFT(RIGHT(H12*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(H12*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(H12*100,2))="0","","角")&"0分")),TEXT(H12*100,"[dbnum2]0分"))))
Q4：表格里怎么设置小写金额转换大写金额
在需要显示大写的单元格中输入
=IF((Z10-INT(Z10))=0,TEXT(Z10,"[DBNUM2]")&"元整",IF(INT(Z10*10)-Z10*10=0,TEXT(INT(Z10),"[DBNUM2]")&"元"&TEXT((INT(Z10*10)-INT(Z10)*10),"[DBNUM2]")&"角整","￥"&TEXT(INT(Z10),"[DBNUM2]")&"元"&IF(INT(Z10*10)-INT(Z10)*10=0,"零",TEXT(INT(Z10*10)-INT(Z10)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(Z10,1),"[DBNUM2]")&"分"))
其中Z10是小写数字所在的单元格。
