excel小写转大写带元整资料

EXCEL如何将小写自动转成大写显示并在元或角后显示整方法一:=IF(ABS(A2)<0.005,"",IF(A2<0,"负",)&IF(INT(ABS(A2)),TEXT(INT(ABS(A2)),