阅读764 返回首页    go 微软 go Office

人民币小写转换为大写

IF(L35=0,"",IF(L35<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(L35)),"[DBNum2]")&"元"&TEXT(RINGHT(TEXT(L35,".00"),2),"[DBNum2]0角0分"),"零角零分","整"),"零分","整",),"零角","零",),"零元零",""))

最后更新：2017-05-12 10:52:21

  上一篇：go Excel免费版Excel选项增加 功能
  下一篇：go 微软账户？？？