excel表格里小写数字怎么转换成大写金额

∩_∩泡泡 2023-03-17 14:49

• 

  ∑月下孤僧≯

  2023-03-17 15:11

  益秋她装良给你编个公式吧=IF(A2<0,"负","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2二属家可独]")&"元"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUN事夜米永态足说阶增D(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".识移历优我0",TEXT(A2,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A2,2),3))=".",TEXT(RIGHT(ROUND(A2,2)),"[DBNum2]")&"分","整")其中"A2"是数字格,即需要转换为大写的那格。
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...