在A1的单元格中输入“101”，在A2中则显示“壹佰零壹元整”，请问如何使用公式达到？

显示全部楼层 · 2012-2-24 09:57:36

A2=IF(A1"",IF(A1,TEXT(INT(A1),"[dbnum2]G/通用格式;[dbnum2]人民币负G/通用格式;")&"元"&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]")&"分"),""),"")...

千问 · 2012-2-24 09:57:36

=IF(ABS(E512)<0.005,"",IF(E512<0,"负",)&IF(INT(ABS(E512)),TEXT(INT(ABS(E512)),"[dbnum2]")&"元",)&IF(INT(ABS(E512)*10)-INT(ABS(E512))*10,TEXT(INT(ABS(E512)*10)-INT(ABS(E512))*10,"[dbn...

千问 · 2012-2-24 09:57:36

=A1, 然后把A2 的单元重新设置，即点右键==设置单元格格式==数字中选=特殊=里面有个“中文大写数字”即可...

千问 · 2012-2-24 09:57:36

格式--单元格--数字--自定义：类型设为：[DBNum2][$-804]G/通用格式"元""整"...

千问 · 2012-2-24 09:57:36

A2=IF(A1="","",A1)&"元"将A2单元格设置为特殊字符——中文大写。...