小写金额转换大写公式!

CHAR48604

学习

lwblxjskyl

<p>这个合我用,学习来</p>

lwblxjskyl

请问,请问楼主,如果我的数字不是放在A2,是否将所有的A2改成其它就行了?<table cellspacing="0" cellpadding="0" width="72" border="0" xstr="" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" width="72" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font size="2">IF(A2=0,"",IF(A2&lt;0,"负","")&amp;SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A2)),"[DBNum2]")&amp;"元"&amp;SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(A2*100,2),"[DBNum2]0角0分"),"零分","整"),"零角","零"),"零元零",),"零元",),"零整","整"))</font></div></td></tr></tbody></table>

aquan9

kk

dalianyingzi

学习学习

cherry-en

看看

yangxinsheng

<p>来学习一行</p><p></p>

jenyle

回复也是对楼主的报答,谢谢了!

蓝色时间

<p>看看哦</p>

dengxia0102

[em01]