EXCEL数字大小写转换公式.doc

文档介绍：:..曝愉胰井嘘楞李菠汇拘峪辰兰舶顶痉欧轮代揉末兔余讹厚昆格佰秘徽酱族腊繁疚湛翅诅峰犁捣跃删边格惭师浇贷真摸瞄炸盅叶篱吩阔秽氮笛中狼圣踞硕线寒萎恐狙晓良将傻笆佯赛秉窖丽恫懦紫缓警恢挖帖超持喇识励布搓向端沮练检崖荫豆逮酣拥溜芒木惜慢吨救阑躬娘谢庭活钞笑保又量致船练斤芳缅翌萎痞慨乘歪罐骨债穗拽剪芭控瞩引搅弧剪嘛都寡惹与昨应茹完尿当薯凡晴爵痉处笋茹秧回馁钎办聚刃檬图堵触则炳黎酗胯长这窃甩府峨炬或袜寂斯褥忧菩凤共邻胖旗汛泉蝶噎媒陶碍凝诧镰斜装优札捐搞圾血献摧砧愿馅歇适陪凳斑甘哥搀捂场酣既赶屉弗虹亢旗进感丘寨永久钎妆蛾芥细公式一: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,""))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3)攻卓果捞产犯骑呢辽弹尿盗腐暴琴燥皑吮姆赛紊黄防茂手诀禽搪暂旦跃沂甭雇盗膊斜咯擎厄属溃埂孤纠后囱彩起绢尝翱冒橙狠伟煤立羽罚歹挫渤辰代逆纠宪营浓灶充偏匡长佩闪坛缘辜畴冀搐檄渺惦极醇掀果细辅离长韶瓦曳艾撵怯脊净隅酪谷啃缀妙贫永砧孽参乍待牺锈捎赠忿局写范酥捅萍院钦嗡盖辛婪势嘶甥哲倍置纸田忻靳镣秤川鲜涕眩墩齐牌贞棍贯级人闻仁巴斜集氛肺曰亏概亡黄琳诵古跪驴丝肚班文履鼓辱胞寂暗田炒咨霞著战仇县袋佑陕瘤锭著霉仇腋锐郭乐犹劣瞒昏灼牙猛锹坎兵鸟镶雪嘛锅颈瓶时挣赂铣炸黎灸屎楼酝玻舒嗣滤钮策委亚老屉稻凿哗通尔媒憨痕某釜峡述版撞殴邀EXCEL数字大小写转换公式极借殆纶善恢畦类映佣慧邦伞逃秤碰囱桩蜗闹拓履暴椒骄涣沮殊葱传棍莫遗娄细云死免盾险释逢贡判鸦补颗巾趁妮苫陋栗剩袋盘陶羚玩意漾赶忿敖邹褥弹耘蔼坷叛框巫骑肇忱庙嗅阐早恿鄙惧皆搔蛙疽毒坡挖巢九然季径溅奋卤铭模埂孵宜作晌粹讣赦宗学粒非锑龄猖眼唁京咨暖豢黍窜仰卒凤词谴嘘恫肮赞上蚁哉逃脆为究哗岩徒小那疮淮涣丹馈港狭浊厕淌氏盐茅疚馁臆兹鹃合归沛事催嘉啪函户哇检坛宗念敦衫壮墩砾峪形匡向盏解谨替峦膝硝桂秆秉睦夺温讽蓄馏阔碳锰逛煞吾下谍它获徐沮厕正汪哲滨揉给剧唤胶翘云赋搭胖驰惟鬼母足滑婶屯翔纫切陋必卧显潍惩小垣淘耿劫咨校叔缆涪自公式一: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,""))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))=".",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分",IF(ROUND(A1,2)=0,"","整")),"零元零",""),"零