問題：小寫是帳頁格式，在excel電子表格中人民幣小寫轉(zhuǎn)換成大寫。

已知：F6=1、G6=2、H6=3、I6=4、J6=5、K6=6、L6=7、M6=8、N6=9、O6=1

函數(shù)：H12= VALUE(F6&G6&H6&I6&J6&K6&L6&M6&N6&O6)/100

結(jié)果：12345678.91

函數(shù)：H14=IF(H12=0,"",IF(INT(H12),TEXT(TRUNC(H12),"[dbnum2]")&"元","")&IF(MOD(H12,1)=0,"整",IF(TRUNC(H12,1),IF(H12=TRUNC(H12,1),TEXT(LEFT(RIGHT(H12*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(H12*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(H12*100,2))="0","","角")&"0分")),TEXT(H12*100,"[dbnum2]0分"))))

結(jié)果：壹仟貳佰叁拾肆萬伍仟陸佰柒拾捌元玖角壹分