第1个回答 2021-06-11
1、首先在电脑中打开excel,选择需要转换为大写金额的数据,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d69dadd57e170828381e30fde0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、鼠标右击单元格,点击“设置单元格格式”,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6f061d950a7b0208bc26418072d9f2d3562cc8e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后在打开的分类中,选择“特殊”,如下图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513df04512bf2d6d55fbb3fbd9e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、接着在打开的右边栏中,选择“中文大写数字”后,点击“确定”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8644ebf81a4c510f2b2b9c7b7059252dd52aa5e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、这时小写数字就自动变成大写了,如下图所示就完成了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d3d539b6003af33b54a201252ac65c1138b6e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳
第2个回答 2017-06-19
比如,小写在E列,大写在F列
选中要显示人民币大写的所有单元格,
然后,在编辑栏中输入:
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(E2),TEXT(E2,";负")&TEXT(INT(ABS(E2)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(E2),2),"[dbnum2]0角0分;;整"),),"零角",IF(E2^2<1,,"零")),"零分","整")
按下CTRL+回车键,
之后,在E列每输入小写数据,F列即自动生成大写
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77094b36acaf2eddab2b19a3871001e9380193a5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第3个回答 推荐于2017-10-11
方法一:=IF(C15<0,零元整,IF(C15=0,,IF(TRUNC(C15)=C7,TEXT(TRUNC(C15),[DBNum2][$-804]G/通用格式)&元整,TEXT(TRUNC(C15),[DBNum2][$-804]G/通用格式)&元&IF(TRUNC((C15)*10)-TRUNC(C15)*10=0,零&TEXT(TRUNC((C15)*100)-TRUNC((C15)*10)*10,[DBNum2][$-804]G/通用格式)&分,TEXT(TRUNC((C15)*10)-TRUNC(C15)*10,[DBNum2][$-804]G/通用格式)&角&IF(TRUNC((C15)*100)-TRUNC((C15)*10)*10=0,整,TEXT(TRUNC((C15)*100)-TRUNC((C15)*10)*10,[DBNum2][$-804]G/通用格式)&分)))))把这些代码复制到你要输出大写金额的格内,然后把C15改成你所要输出的小写金额的代号。方法二:右键点击需要转换的阿拉伯数字单元格→选择设置单元格格式→选择特殊中的中文大写数字类型→点击确定按钮即可。详见下图:显然,对于大多数Excel使用者而言,方法二很便捷;但是,对于Excel发烧友来说,恐怕方法一更具挑战性与启示作用。本回答被提问者采纳