发表: 2008-10-25 09:58 | IP已记录
|
|
|
EXCELL中将小写数字转为大写金额的两种方法:
第一种:IF嵌套方式 =IF(ROUND(C6,2)<0,"无效数值",IF(ROUND(C6,2)=0,"零",IF(ROUND(C6,2)<1,"",TEXT(INT(ROUND(C6,2)),"[dbnum2]")&"元")&IF(MOD(INT(ROUND(C6,2)*10),10)=0,IF(INT(ROUND(C6,2))*MOD(INT(ROUND(C6,2)*100),10)=0,"","零"),TEXT(MOD(INT(ROUND(C6,2)*10),10),"[dbnum2]")&"角")&IF(MOD(INT(ROUND(C6,2)*100),10)=0,"整",TEXT(MOD(INT(ROUND(C6,2)*100),10),"[dbnum2]")&"分")))
第二种:dbnum2 格式
=TEXT(C6*100,"[DBNUM2]0拾0万0仟0佰0拾0元0角0分整")
但第二种方法要自己调整最大位数的格式 C6为要转换的单元格
__________________ 坐下来,留给自己一点时间,听听心里的声音,品味心情~~~~
|