我初使用该表，不太熟悉，请老师能详细说一下步骤。谢谢！我也从该问题的搜索答案中试过，但一直不成功，郁闷。
a1输入数字
其他单元格输入这个
=IF(A1=0,"零",IF(A1>-0.5%,,"负")&TEXT(INT(ABS(A1)),"[dbnum2]G/通用格式元;;")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"),"零角",IF(ABS(A1)<1,,"零")),"零分","整"))
其他单元格输入这个
=IF(A1=0,"零",IF(A1>-0.5%,,"负")&TEXT(INT(ABS(A1)),"[dbnum2]G/通用格式元;;")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"),"零角",IF(ABS(A1)<1,,"零")),"零分","整"))
温馨提示：答案为网友推荐，仅供参考
