=IF(A2=0,"零元",IF(A2<0,TEXT(INT(ABS(A2)),"负[DBNum2]g/通用格式")&"元"&IF((INT(A2*10)-INT(A2)*10)=0,"",TEXT(INT(A2*10)-INT(A2)*10,"[DBNum2]")&"角")&IF((INT(A2*100)-INT(A2*10)*10)=0,"整",TEXT(INT(A2*10)-INT(A2*10),"[DBNum2]")&TEXT(INT(A2*100)-INT(A2*10)*10,"[DBNum2]")&"分"),TEXT(INT(A2),"[dbnum2]")&"元"&IF(INT(A2*10)-INT(A2)*10=0,"",TEXT(INT(A2*10)-INT(A2)*10,"[dbnum2]")&"角")&IF((INT(A2*100)-INT(A2*10)*10)=0,"整",TEXT(INT(A2*10)-INT(A2*10),"[DBNum2]")&TEXT(INT(A2*100)-INT(A2*10)*10,"[DBNum2]")&"分")))

其中：A2为数字金额所在的单元格。

标签 财务