有小数点的数字怎么变成大写，急!!!!

longruby · 发表于 2009-7-28 11:14

比好：12535.67元怎么变成大写壹万贰仟伍佰参拾伍点陆角柒分

longruby · 发表于 2009-7-28 11:15

急!!!!!!!!!!!!!!!!

zhc_ling · 发表于 2009-7-28 11:24

=SUBSTITUTE(SUBSTITUTE(IF(G10<0,"負","")&TEXT(TRUNC(ABS(ROUND(G10,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(G10,2))),"",TEXT(RIGHT(TRUNC(ROUND(G10,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(G10,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(G10,2),3))=".",TEXT(RIGHT(ROUND(G10,2)),"[DBNum2]")&"分",IF(ROUND(G10,2)=0,"","整")),"零元零",""),"零元","")

把G10改成你要的单元格

eqzh · 发表于 2009-7-28 11:27

搜索一下大写转换函数

987654321 · 发表于 2009-7-28 11:27

请参考......

dengjq2000 · 发表于 2009-7-28 11:33

我也一个……

fenghcl · 发表于 2009-7-28 13:36

假设的数字金额在C2

=IF(ISTEXT(C2),"","人民币："&TEXT(INT(C2),"[dbnum2]")&"元"&IF(INT(C2*10)-INT(C2)*10=0,"",TEXT(INT(C2*10)-INT(C2)*10,"[dbnum2]")&"角")&IF(INT(C2*100)-INT(C2*10)*10=0,"整",TEXT(INT(C2*100)-INT(C2*10)*10,"[dbnum2]")&"分"))

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

[求助] 有小数点的数字怎么变成大写，急!!!!

回复 1楼 longruby 的帖子