如何用EXCEL把小写钱码用大写方式反映

_melody_200 2023-06-21 09:22

• 

  _P_erhaps

  2023-06-21 09:56

  用单元格格式在A1 输入 123.32="￥"&IF(ISERROR(FIND(".",A1)),NUMBERSTRING(INT(A1),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(A1,备派生FIND(".",A1)+2,1),2)),NUMBERSTRING(INT(A1),2)&"元"&NUMBERSTRING(MID(A1,FIND(".",A1)+1,1),2)&"角整",NUMBERSTR来自ING(INT(旧担队项A1),2)&"元"&NUMBERSTRING(MID(A1,FIND(".",A1)+1,1),2)&"角"&NUMBERSTRING(MID(A1,FIND(".",A1)+2,1),2)&"分"))
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...