105.2转成壹佰零伍元贰角整 excel
=IF(A1=0,"",CONCATENATE(IF(INT(A1)=0,"",TEXT(INT(A1),"[DBNum2]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
原创
2015-02-02 10:50:06 ·
1170 阅读 ·
0 评论