B1 输入公式
=IF(A1,TEXT(INT(A1),"[dbnum2]G/通用格式;[dbnum2]负G/通用格式;")&"元"&IF(INT(A1*10)-INT(A1)*10=0,IF(INT(A1)*(INT(A1*100)-INT(A1*10)*10)=0,"","零"),TEXT(INT(A1*10)-INT(A1)*10,"[dbnum2]")&"角")&IF((INT(A1*100)-INT(A1*10)*10)=0,"整",TEXT((INT(A1*100)-INT(A1*10)*10),"[dbnum2]")&"分"),"")
这样A1输入数字,B1 直接显示 大写金额