Excel数字小写转换为大写公式.docx

文档介绍：=SUBSTITUTE(SUBSTITUTE(IF(-RMB(B1),IF(B1>0,," 负")&TEXT(INT(ABS(B1)+%),"[dbnum2]G/ 通用格式元;;")&TEXT(RIGHT(RMB(B1,2),2),"[dbnum2] 0角0分;;整"),)," 零角",IF(B1^2<1,," 零"))," 零分"," 整") =IF(H14=0,"",CONCATENATE(IF(INT(ABS(H14))=0,"",TEXT(INT(ABS(H14)),"[DBNum2]G/ 通用格式元")),IF(INT(MID(RIGHT(FIXED(ABS(H14),2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED(H14,2,1),1),1,1))=0, "",IF(INT(ABS(H14))=0,""," 零")),TEXT(INT(MID(RIGHT(FIXED(H14,2,1),2),1,1)),"[DBNum2]G/ 通用格 式角")),IF(INT(MID(RIGHT(FIXED(H14,2,1),1),1,1))=0," 整",TEXT(INT(MID(RIGHT(FIXED(H14,2,1),1),1,1)),"[DBNum2]G/ 通用格式分"))))