在EXCEL中小写数字设置成大写数字

来源：百度知道 编辑：UC知道 时间：2024/05/05 02:48:29
例如:在A1单元格中输入130450,在B2单元格中显示为:壹拾叁万零肆佰伍拾元整

或在A5单元格中130450.07 在B6单元格中显示为:壹拾叁万零肆佰伍拾元零柒分,

IF(A1=0,"",IF(ABS(A1)<0.995,"",TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2]")&"元")&IF(RIGHT(TEXT(A1,".00"),2)*1=0,IF(ABS(A1)<0.005,"","整"),TEXT(IF(ABS(A1)<0.095,"",LEFT(RIGHT(TEXT(A1,".00"),2))),"[dbnum2]")&IF(LEFT(RIGHT(TEXT(A1,".00"),2))*1=0,"","角")&IF(RIGHT(TEXT(A1,".00"))*1=0,"整",TEXT(RIGHT(TEXT(A1,".00")),"[dbnum2]")&"分")))

说明在http://fanju.blog.hexun.com/1549898_d.html

在A1中写好130450后，复制到B2
在b2上点右键选择设置单元格格式
选数字选项卡
选分类里的特殊
右边出现的选择框中选类型为中文大写数字

[<10][DBNum2]"零"G/通用格式;[>=10][DBNum2]G/通用格式