如果你的金额在A1单元格，
=IF(A1=0,"",CONCATENATE(IF(INT(A1)=0,"",TEXT(INT(A1),"人民币
[DBNum2][$-804]G/通用格式元
")),IF(INT(MID(RIGHT(FIXED(A1,2,1),2),1,1))=0,IF(INT(MID(RIGHT(FIXED(A1,2,1)
,1),1,1))=0,"",IF(INT(A1)=0,"","零")),TEXT(INT(MID(RIGHT(FIXED(A1,2,1),2),1,
1)),"[DBNum2][$-804]G/通用格式角
")),IF(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1))=0,"整
",TEXT(INT(MID(RIGHT(FIXED(A1,2,1),1),1,1)),"[DBNum2][$-804]G/通用格式分
"))))
复制上去就可以了
