EXCEL表格中数字大写的自动生成公式 EXCEL表格中当AI单元是小写数字,要把A2单元中直接变成A1中的数字的大写,则在A2中输入以下公式即可。自己任意修改公式中的A1,哪个单元都行。 =IF(A1=0,"",IF(INT(A1),TEXT(TRUNC(A1),"[dbnum2]")&"元","")&IF(MOD(A1,1)=0,"整",IF(TRUNC(A1,1),IF(A1=TRUNC(A1,1),TEXT(LEFT(RIGHT(A1*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(A1*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(A1*100,2))="0","","角")&"0分")),TEXT(A1*100,"[dbnum2]0分"))))
|
|