EXCEL 单元格里的货币(含小数点)数字格式如何用公式转为文本?
发布网友
发布时间：2022-04-23 01:04
共4个回答
热心网友
时间：2023-07-27 15:01
人民币转换成大写公式：=IF(A1<0,"无效值","人民币"&IF(A1=0,"零元",IF(A1<1,"",TEXT(INT(A1),"[DBNUM2]")&"元")&IF(INT(A1*10)-INT(A1)*10=0,IF((INT(A1)*(INT(A1*100)-INT(A1*10)*10))=0,"","零"),TEXT(INT(A1*10)-INT(A1)*10,"[DBNUM2]")&"角")&IF(INT(A1*100)-INT(A1*10)*10=0,"整",TEXT(INT(A1*100)-INT(A1*10)*10,"[DBNUM2]")&"分")))
热心网友
时间：2023-07-27 15:01
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A2),IF(A2>0,,"负")&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(A2,2),2),"[dbnum2]0角0分;;正"),),"零角",IF(A2^2<1,,"零")),"零分","正")
热心网友
时间：2023-07-27 15:02
选中单元格，右击设置单元格格式，选择数字，特殊（倒数第二项），选择中文大写数字 就 ok 了
热心网友
时间：2023-07-27 15:02
=SUBSTITUTE(IF(A2,IF(A2<0,"负",)&TEXT(TRUNC(A2),"[dbnum2]g/通用格式元;[dbnum2]g/通用格式元;")&TEXT(RIGHT(RMB(A2),2),"[>9][dbnum2]0角0分;[>0][dbnum2]00分;整"),"零元"),"零分","整")
