请指教.

yfdige1 · 发表于 2006-10-25 18:11

各位老师.你们有没有办法把小写12254.33,变成壹万贰仟贰佰伍拾肆元叁角叁分.谢谢,帮忙.急切....切

daley · 发表于 2006-10-25 18:21

<a href="http://club.excelhome.net/viewthread.php?tid=193860&replyID=&skin=0">http://club.excelhome.net/viewthread.php?tid=193860&replyID=&skin=0</a>

LangQueS · 发表于 2006-10-25 18:38

当A1是小写金额B1=SUBSTITUTE(SUBSTITUTE(IF(A1<0,"负","")&TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))=".",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分",IF(ROUND(A1,2)=0,"","整")),"零元零",""),"零元","")

jsrccb502803 · 发表于 2006-10-25 18:47

=IF(ROUND(B22,2)<0,"无效数值",IF(ROUND(B22,2)=0,"零",IF(ROUND(B22,2)<1,"",TEXT(INT(ROUND(B22,2)),"[dbnum2]")&"元")&IF(INT(ROUND(B22,2)*10)-INT(ROUND(B22,2))*10=0,IF(INT(ROUND(B22,2))*(INT(ROUND(B22,2)*100)-INT(ROUND(B22,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(B22,2)*10)-INT(ROUND(B22,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(B22,2)*100)-INT(ROUND(B22,2)*10)*10)=0,"整",TEXT((INT(ROUND(B22,2)*100)-INT(ROUND(B22,2)*10)*10),"[dbnum2]")&"分")))式中B22是小写所在单元格。

yfdige1 · 发表于 2006-10-26 08:35

谢谢.二楼的.你的我可以用上.三楼的哥们.我不知道你哪个小写数字是哪个单元格. 用是可以用.只是不懂那些函数是什么意思

yfdige1 · 发表于 2006-10-26 08:37

刚才写错了,不好意思 谢谢.三楼的.你的我可以用上.四楼的哥们.我不知道你哪个小写数字是哪个单元格. 用是可以用.只是不懂那些函数是什么意思

yfdige1 · 发表于 2006-10-27 08:59

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用daley在2006-10-25 18:21:03的发言： <a href="http://club.excelhome.net/viewthread.php?tid=193860&replyID=&skin=0">http://club.excelhome.net/viewthread.php?tid=193860&replyID=&skin=0</a></div>不懂什么意思,不过我复制过去都是可以用的.谢谢啦.

yfdige1 · 发表于 2006-10-27 09:01

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用LangQueS在2006-10-25 18:38:57的发言： 当A1是小写金额B1=SUBSTITUTE(SUBSTITUTE(IF(A1<0,"负","")&TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))=".",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分",IF(ROUND(A1,2)=0,"","整")),"零元零",""),"零元","")</div>复制你的可以用了.只是不懂是什么意思.呵,谢谢了.

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

[求助] 请指教.