第1个回答 2012-04-23
小写数字不会是一个一个的输入的吧,通常都是引用的其他单元格的数据,所以用一个大写金额公式就可以了,如B1是小写数字:=CONCATENATE(IF(INT(ABS(B1))=0,"","(人民币):"&TEXT(INT(ABS(B1)),"[DBNum2]G/通用格式元")),IF(INT(MID(RIGHT(FIXED(ABS(B1),2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED(B1,2,1),1),1,1))=0,"",IF(INT(ABS(B1))=0,"","零")),TEXT(INT(MID(RIGHT(FIXED(B1,2,1),2),1,1)),"[DBNum2]G/通用格式角")),IF(INT(MID(RIGHT(FIXED(B1,2,1),1),1,1))=0,"整",TEXT(INT(MID(RIGHT(FIXED(B1,2,1),1),1,1)),"[DBNum2]G/通用格式分")))本回答被网友采纳