如何在EXCEL数字小写换大写

_7花月夜7_ 2023-08-11 09:55

• 

  _M30_

  2023-08-11 10:33

  假设***数字单元格在C10革书么例击，设置公式如下: =IF(C10<0,"金额为负导山推名无效",IF(OR(C10被助井息创命故=0,C10=""),"零元整",IF(C10<1,"白",TEXT(INT(C10)超即,"[dbnum2]G/通用格式")&"元"))) & IF(INT(C10*10)-INT(C10)*10=0,IF(INT(C10)*(INT(C10*100)-INT(C10*10)*10)=0,"","零"),TEXT(INT(C10*10)-INT(C10)*10,"[dbnum2]")&"角")&IF((INT(C10*10城修林句清医0)-INT(C10*10)*10)=0,"整",TEXT((INT(C10*100)-INT(C10*10)*10),"[dbnum2]")&"分")
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...