把Excel中數(shù)字變元角分

把下面的公式，復(fù)制到要填寫大寫元角分的單元格內(nèi),，利用查找—與—替換,，把公式中的G12，替換成有“小寫數(shù)字”的的單元格,。即可,！

=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/通用格式")&"分"))