把Excel中数字变元角分

把Excel中数字变元角分

 

把下面的公式，复制到要填写大写元角分的单元格内，利用查找—与—替换，把公式中的G12，替换成有“小写数字”的的单元格。即可！

 

=IF((INT(G12*10)-INT(G12)*10)=0,TEXT(INT(G12),"[DBNum2]G/通用格式")&"元"&IF((INT(G12*100)-INT((G12)*10)*10)=0,"整","零"&TEXT(INT(G12*100)-INT(G12*10)*10,"[DBNum2]G/通用格式")&"分"),TEXT(INT(G12),"[DBNum2]G/通用格式")&"元"&IF((INT(G12*100)-INT((G12)*10)*10)=0,TEXT((INT(G12*10)-INT(G12)*10),"[DBNum2]G/通用格式")&"角整",TEXT((INT(G12*10)-INT(G12)*10),"[DBNum2]G/通用格式")&"角"&TEXT(INT(G12*100)-INT(G12*10)*10,"[DBNum2]G/通用格式")&"分"))