数字大写转换

bbwsj · 发表于 2011-1-9 09:52

菜单-格式-单元格-数字-特殊-中文大写数字

wayy · 发表于 2011-1-9 10:49

金额小写转大写的方法有几种，都比较麻烦的，简单点的用自定义函数吧

天意fe · 发表于 2011-1-9 12:38

学习了

sunjing-zxl · 发表于 2011-1-9 13:34

=IF(E32<0,"负",)&SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(E32)),"[dbnum2]")&"圆"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(TEXT(E32,"0.00"),2),"[dbnum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零"),"零圆零",""),"零圆","")

sunjing-zxl · 发表于 2011-1-9 13:34

=SUBSTITUTE(SUBSTITUTE(IF(E32<0,"负",)&TEXT(INT(ABS(E32)),"[dbnum2]G/通用格式圆;;")&TEXT(RIGHT(ABS(E32)/1%,2),"[=0]整;[="&RIGHT(E32)*10&"]"&TEXT(RIGHT(E32),"[dbnum2]")&"角整;[dbnum2]0角0分"),"圆零角","圆零"),"零角",)

sunjing-zxl · 发表于 2011-1-9 13:35

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(E41<0,"负",)&TEXT(INT(ABS(E41)),"[dbnum2]G/通用格式圆;;")&IF(INT(E41)=E41,"整",TEXT(RIGHT(TEXT(E41,".00"),2),"[dbnum2]0角0分")),"圆零角","圆零"),"零分","整"),"零角",)

sunjing-zxl · 发表于 2011-1-9 13:35

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(B8<0,"负",)&TEXT(INT(ABS(B8)),"[dbnum2];; ")&TEXT(MOD(ABS(B8)*100,100),"[>9][dbnum2]圆0角0分;[=0]圆整;[dbnum2]圆零0分"),"零分","整")," 圆零",)," 圆",)

Aкon · 发表于 2011-1-9 14:43

找个问题来学习

yjscia520 · 发表于 2011-1-9 15:15

在菜单中--格式--单元格--数字--特殊--中文大写数字--确定
按如上一步步设置就行了

yjscia520 · 发表于 2011-1-9 15:20

=NUMBERSTRING(A1,3)

		自动登录	找回密码
密码			注册