excel数字小写自动转大写
=IF(E13=0,"",IF(ABS(E13)<1,"",TEXT(TRUNC(ABS(E13)),"闹模[DBNum2]")&"元吵拆")&IF(RIGHT(TRUNC(E13*100),2)*1=0,IF(ABS(E13)<0.01,"","整"),IF(ABS(E13)<0.1,"",TEXT(RIGHT(TRUNC(E13*10)),"[dbnum2]"))&IF(RIGHT(TRUNC(E13*10))*1=0,"","角")&IF(RIGHT(TRUNC(E13*100))*1=0,"整",TEXT(RIGHT(TRUNC(E13*100)),"[dbnum2]")&"分")))
将E13替换成你所要液碰缓转换的单元格即可。
设置单无格格式中有一“特殊”选项中有“中文大写数字”格式
单元格格式》数字》特殊》中文大写数字
单元格设置-->自定义--->数字-->类型