第1个回答 2022-12-01
可以通过单元格设置方式进行转换,具体操作步骤如下:
工具/原材料
excel2016版、电脑。
1、打开电脑找到并双击打开excel2016版表格软件;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5243fbf2b2119313d3ca3e206b380cd790238d91?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、双击打开excel表格软件以后,为了更好的示范在A列中编辑好任意的数字文本;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9825bc315c6034a8c4697911c513495408237693?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、编辑好任意数字以后,选中A列后鼠标右键选择设置单元格格式的命令;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800ab067489ebf3533fa838b47a4?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/314e251f95cad1c811ab3cb7713e6709c93d510a?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/f7246b600c338744ac96efec5f0fd9f9d62aa0cb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第2个回答 2009-10-19
两种方法:
1、调整单元格格式,在 数字-〉分类 中选特殊,在类型中选中文大写数字
2、假如数字在A1,可在其他单元格输入:
=TEXT(A1,"[DBNum2]")
即可转换为大写
根据你提的要求
你可以试试这个公式
=TEXT(INT(A1),"[DBNum2]G/通用格式元")&IF(INT(A1*10)-INT(A1)*10,TEXT((A1-INT(A1))*10,"[DBNum2]0角"),"零")&IF(INT(A1*100)-INT(A1*10)*10,TEXT(INT(A1*100)-INT(A1*10)*10,"[DBNum2]0分"),"整")
可以判断有没有角和分,并分别表示
如果需要更多的要求,你提出来,在此基础上可以进一步完善
我觉得二楼的做的公式比我的好,还是用他的吧
第3个回答 推荐于2017-09-14
若是03版,比如在a1输小写金额,只能在除a1之外的单元格(如b1)显示大写金额,则
b1=TEXT(INT(A1),"[dbnum2]")&IF(INT(A1)=A1,"元整","元")&IF(ISERROR(FIND(".",A1))=TRUE,"",IF(LEN(A1)-FIND(".",A1)=1,TEXT(RIGHT(A1,1),"[dbnum2]")&"角",IF(AND(LEN(A1)-FIND(".",A1)=2,MID(A1,LEN(A1)-1,1)<>"0"),TEXT(MID(A1,LEN(A1)-1,1),"[dbnum2]")&"角"&TEXT(RIGHT(A1,1),"[dbnum2]")&"分","零"&TEXT(RIGHT(A1,1),"[dbnum2]")&"分"))),直接复制公式到b1就行了本回答被提问者采纳