(相关资料图)

1、=IF(E13=0,"",IF(ABS(E13)<1,"",TEXT(TRUNC(ABS(E13)),"[DBNum2]")&"元")&IF(RIGHT(TRUNC(E13*100),2)*1=0,IF(ABS(E13)<0.01,"","整"),IF(ABS(E13)<0.1,"",TEXT(RIGHT(TRUNC(E13*10)),"[dbnum2]"))&IF(RIGHT(TRUNC(E13*10))*1=0,"","角")&IF(RIGHT(TRUNC(E13*100))*1=0,"整",TEXT(RIGHT(TRUNC(E13*100)),"[dbnum2]")&"分"))) 将E13替换成你所要转换的单元格即可。

本文就为大家分享到这里，希望小伙伴们会喜欢。

关键词：