excel中将金额进行转换就比较复杂一点,总之都是利用函数就可以达到目的了将H7格的数字转换为大写金额,在目标格内输入=IF(H7="","",IF(H7<0,"负",)&IF(INT(H7),TEXT(INT(ABS(H7)),"[dbnum2]")&"元",)&IF(INT(ABS(H7)*10)-INT(ABS(H7))*10,TEXT(INT(ABS(H7)*10)-INT(ABS(H7))*10,"[dbnum2]")&"角",IF(INT(ABS(H7))=ABS(H7),,IF(ABS(H7)<0.1,,"零")))&IF(ROUND(ABS(H7)*100-INT(ABS(H7)*10)*10,),TEXT(ROUND(ABS(
|