问题:怎么才能把在单元格里1000.56转换成人民币中文大写“壹仟元伍角陆分正”
已知:H6=1000.50 (其中:H6改成你对应的小写单元格)。 函数:=IF(H6<0.005,"",IF(H6<0,"负",)&IF(INT(ABS(H6)),TEXT(INT(ABS(H6)),"[dbnum2]")&"元",)&IF(INT(ABS(H6)*10)-INT(ABS(H6))*10,TEXT(INT(ABS(H6)*10)-INT(ABS(H6))*10,"[dbnum2]")&"角",IF(INT(ABS(H6))=ABS(H6),,IF(ABS(H6)<0.1,,"零")))&IF(ROUND(ABS(H6)*100-INT(ABS(H6)*10)*10,),TEXT(ROUND(ABS(H6)*100-INT(ABS(H6)*10)*10,),"[dbnum2]")&"分","整")) 结果:壹仟元伍角陆分 |
|
来自: 甘苦人生2010 > 《execl在会计上的应用》