Ravo's Blog - 金额
type: channel
link: https://www.ravo.top/tag/%E9%87%91%E9%A2%9D/
items: Excel金额数字自动转大写

Excel金额数字自动转大写
type: item
date: 2022-03-14T12:02:41+08:00
description: 办公中经常遇到Excel中金额是数字，需要手动转为大写，有没有输入数字自动转为大写的呢？答案是肯定的，具体如下：1、新建excel表格，在A1中输入以下内容：=IF(B2=0,"零元",IF(B2<0,TEXT(INT(ABS(B2)),"负[DBNum2]g/通用格式")&"元"&IF((INT(B2*10)-INT(B2)*10)=0,"",TEXT(INT(B2*10)-INT(B2)*10,"[DBNum2]")&"角")&IF((INT(B2*100)-INT(B2*10)*10)=0,"整",TEXT(INT(B2*10)-INT(B2*10),"[DBNum2]")&TEXT(INT(B2*100)-INT(B2*10)*10,"[DBNum2]")&"分"),TEXT(INT(B2),"[dbnum2]")&"元"&IF(INT(B2*10)-INT(B2)*10=0,"",TEXT(INT(B2*10)-INT(B2)*10,"[dbnum2]")&"角")&IF((INT(B2*100)-INT(B2*10)*10)=0,"整",TEXT(INT(B2*10)-INT(B2*10),"[DBNum2]")&TEXT(INT(B2*100)-INT(B2*10)*10,"[DBNum2]")&"分")))2、在B2中输入你需要转换的数字金额，A1中就会出现自动转换的大写金额了。