閱讀764 返回首頁    go windows 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 微軟賬戶？？？