EXCEL高手，将某一单元格中的小写金额能转换成大写的金额吗

有没有人在啊，想请问下，EXCEL高手，将某一单元格中的小写金额能转换成大写的金额吗
最新回答
温柔姐无与伦比

2025-06-26 13:51:23

可以通过公式实现 看看一下的哪个适合你 (以等号开始为一个公式)
=TEXT(INT(A5),"[DBNum2]")&"元"&TEXT(INT(A5*10)-INT(A5)*10,"[DBNum2]")&"角"&TEXT(INT(A5*100)-INT(A5*10)*10,"[DBNum2]")&"分"

=IF(A5<0,REPLACE(IF(TRUNC(A5)=A5,TEXT(A5,"[DBNum2]")&"元整",IF(TRUNC(A5*10)=A5*10,TEXT(TRUNC(A5),"[DBNum2]")&"元"&TEXT(RIGHT(A5),"[DBNum2]")&"角整",TEXT(TRUNC(A5),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".0",A5)),"零",TEXT(LEFT(RIGHT(A5,2)),"[DBNum2]")&"角")&TEXT(RIGHT(A5),"[DBNum2]")&"分")),1,1,"负"),IF(TRUNC(A5)=A5,TEXT(A5,"[DBNum2]")&"元整",IF(TRUNC(A5*10)=A5*10,TEXT(TRUNC(A5),"[DBNum2]")&"元"&TEXT(RIGHT(A5),"[DBNum2]")&"角整",TEXT(TRUNC(A5),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".0",A5)),"零",TEXT(LEFT(RIGHT(A5,2)),"[DBNum2]")&"角")&TEXT(RIGHT(A5),"[DBNum2]")&"分")))

=IF(A5<0,REPLACE(IF(TRUNC(A5)=A5,TEXT(A5,"[DBNum2]")&"元整",IF(TRUNC(A5*10)=A5*10,TEXT(TRUNC(A5),"[DBNum2]")&"元"&TEXT(RIGHT(A5),"[DBNum2]")&"角整",TEXT(TRUNC(A5),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".0",A5)),"零",TEXT(LEFT(RIGHT(A5,2)),"[DBNum2]")&"角")&TEXT(RIGHT(A5),"[DBNum2]")&"分")),1,1,"负"),IF(TRUNC(A5)=A5,TEXT(A5,"[DBNum2]")&"元整",IF(TRUNC(A5*10)=A5*10,TEXT(TRUNC(A5),"[DBNum2]")&"元"&TEXT(RIGHT(A5),"[DBNum2]")&"角整",TEXT(TRUNC(A5),"[DBNum2]")&"元"&IF(ISNUMBER(FIND(".0",A5)),"零",TEXT(LEFT(RIGHT(A5,2)),"[DBNum2]")&"角")&TEXT(RIGHT(A5),"[DBNum2]")&"分")))

=IF(ISNUMBER(A5),IF(TRUNC(A5)=0,IF(AND(MID(TEXT(TRUNC(A5,2),"0.00"),LEN(TEXT(TRUNC(A5,2),"0.00"))-1,1)="0",RIGHT(TEXT(TRUNC(A5,2),"0.00"),1)="0"),"零元",""),TEXT(TRUNC(A5),"[DBNUM2]")&"元")&(IF(MID(TEXT(TRUNC(A5,2),"0.00"),LEN(TEXT(TRUNC(A5,2),"0.00"))-1,1)="0",IF(OR(TRUNC(A5)=0,RIGHT(TEXT(TRUNC(A5,2),"0.00"),1)="0"),"","零"),TEXT(MID(A5,LEN(TEXT(TRUNC(A5,2),"0.00"))-1,1),"[DBNUM2]")&"角"))&(IF(RIGHT(TEXT(TRUNC(A5,2),"0.00"),1)="0","",TEXT(RIGHT(TEXT(TRUNC(A5,2),"0.00"),1),"[DBNUM2]")&"分")),IF(A5="","","不是有效金额,请重新输入!"))

=IF(ISNUMBER(A5),IF(TRUNC(A5)=0,IF(AND(MID(TEXT(TRUNC(A5,2),"0.00"),LEN(TEXT(TRUNC(A5,2),"0.00"))-1,1)="0",RIGHT(TEXT(TRUNC(A5,2),"0.00"),1)="0"),"零元",""),TEXT(TRUNC(A5),"[DBNUM2]")&"元")&(IF(MID(TEXT(TRUNC(A5,2),"0.00"),LEN(TEXT(TRUNC(A5,2),"0.00"))-1,1)="0",IF(OR(TRUNC(A5)=0,RIGHT(TEXT(TRUNC(A5,2),"0.00"),1)="0"),"","零"),TEXT(MID(A5,LEN(TEXT(TRUNC(A5,2),"0.00"))-1,1),"[DBNUM2]")&"角"))&(IF(RIGHT(TEXT(TRUNC(A5,2),"0.00"),1)="0","整",TEXT(RIGHT(TEXT(TRUNC(A5,2),"0.00"),1),"[DBNUM2]")&"分")),IF(A5="","","不是有效金额,请重新输入!"))

还有很多 可以到 club.excelhome.net 搜索一下
枕花眠

2025-06-26 05:41:38

选中单元格→单击鼠标右键→设置单元格格式→数字→特殊→中文大写数字→确定。
搞定，收工！
残暴的安妮

2025-06-26 16:17:54

当然可以了，你可以右击该这个单元格，然后选择 设置单元格格式 ，在数字选项卡的 分类 栏目下点击 特殊。右边点击 中文大写数字，确定就可以了
试卷看似简单但心机太重

2025-06-26 19:45:47

这个在百度里回答很多次了哦，而且你动动手的话，一搜一大片。
纯家小可爱

2025-06-26 04:05:49

其中一个公式=IF(ABS(A1)<0.005,"",IF(A1<0,"负",)&IF(INT(ABS(A1)),TEXT(INT(ABS(A1)),"[dbnum2]")&"元",)&IF(INT(ABS(A1)*10)-INT(ABS(A1))*10,TEXT(INT(ABS(A1)*10)-INT(ABS(A1))*10,"[dbnum2]")&"角",IF(INT(ABS(A1))=ABS(A1),,IF(ABS(A1)<0.1,,"零")))&IF(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),TEXT(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),"[dbnum2]")&"分","整"))
醉酒吟春秋

2025-06-26 00:02:39

能，比如1234要变大写壹贰叁肆，具体步骤是这样的，用搜狗拼音输入法v加小写数字，完成后按
enter就可以了

您可能感兴趣问答

Collapsible

热门标签

编程 Python Microsoft 编程语言 C++ C（编程语言） Java javascript PHP 前端开发 MySQL Office 计算机 Excel Java编程 数据库 vue dedecms 计算机语言 数据

热点问答