导读 =IF(E13=0,"",IF(ABS(E13)
=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替换成你所要转换的单元格即可。
版权声明：转载此文是出于传递更多信息之目的。若有来源标注错误或侵犯了您的合法权益，请作者持权属证明与本网联系，我们将及时更正、删除，谢谢您的支持与理解。