金额大写與拆到適當位置 (11582)

H5:H10=LEFT(RIGHT(" "&$S5/1%,10-COLUMN(A1)))

C11=TEXT(INT(S11),"[DBNUM2]")&"元"&TEXT(ROUND(MOD(S11,1)/1%,),"[DBNUM2]0角0分")


留言