Simone在Excel中输入小写金额怎样自动显示大写金额
的有关信息介绍如下：
假设小写金额备锋陵在A1中，在B1中输入="人民币大写￥"&IF(INT(A1)=0,基伍"",TEXT(INT(A1),"[DBNum2]")&"元")&IF(OR(INT(A1*10)=0,INT(A1)=A1),"",IF(INT(A1*10)=INT(A1)*10,"零",RIGHT(TEXT(INT(A1*10),"[DBNum2]"仿戚),1)&"角"))&IF(INT(A1*100)=INT(A1*10)*10,"整",RIGHT(TEXT(ROUND(A1,2),"[DBNum2]"),1)&"分")
