Question

excel 中123456.78如何转换成壹贰叁肆伍陆柒捌，就是把每个数字单独转换大写不需要转小数点，谢谢函数出现

谢谢刚才的同学~~但是我的初衷不是这样的~
我单位的凭单是这样的·~上面的是123456.78
下面是（壹)拾(贰)万(叁)仟(肆)佰(伍)拾(陆)元(柒)角(捌)分,货币单位已经固定表上有了~我想把上面的数字转了大写直接套下去这样而已~~请问应该怎么换？？或者换个思路~就是在货币单位那里留空一个位置就可以了~谢谢大家了！！

Answer 1

()仟()佰()拾()万()仟()佰()拾()元()角()分
10个括号从左到右内依次为：
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>9,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-9,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>8,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-8,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>7,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-7,1),"/")
。
。
。
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>2,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-2,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>1,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-1,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>0,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0")),1),"/")

Answer 2

=TEXT(A1*100,"0[DBNum2]")

Answer 3

=TEXT(SUBSTITUTE(A1,".",""),"[dbnum2]0")