如何把阿拉伯数字转换成大写数字

如何把阿拉伯数字转换成大写数字

回复
  • 郑翰飞用户
    [[{"txt": "\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u8d22\u52a1\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u7ecf\u5e38\u9700\u8981\u628a\u963f\u62c9\u4f2f\u6570\u5b57\u8f6c\u6362\u6210\u5927\u5199\u6570\u5b57\uff0c\u5982\u679c\u624b\u52a8\u8f93\u5165\u7684\u8bdd\u662f\u4e2a\u8d39\u65f6\u8d39\u529b\u7684\u4e8b\uff0c\u6211\u4eec\u53ef\u4ee5\u501f\u52a9\u51fd\u6570\u516c\u5f0f\u6216\u5176\u4ed6\u65b9\u6cd5\uff0c\u628a\u963f\u62c9\u4f2f\u6570\u5b57\u81ea\u52a8\u8f6c\u6362\u6210\u5927\u5199\u6570\u5b57\u3002"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u7535\u8111"}, {"txt": "Excel"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u5982\u679c\u9700\u8981\u8f93\u5165\u7684\u6570\u5b57\u9a6c\u4e0a\u5c31\u663e\u793a\u4e3a\u5927\u5199\u6570\u5b57\uff0c\u53ef\u4ee5\u9009\u62e9\u5355\u5143\u683c\uff0d\u53f3\u952e\uff0d\u5355\u5143\u683c\u683c\u5f0f\uff0d\u6570\u5b57\uff0d\u81ea\u5b9a\u4e49\uff0c\u5728\u7c7b\u578b\u680f\u8f93\u51650[dbnum2]\uff0c\u70b9\u786e\u5b9a\u5373\u53ef\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/76b6860e5f20437135ecab93323acd8921c58f8e.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fd9\u4e00\u95ee\u9898\u4e5f\u53ef\u4ee5\u7528\u51fd\u6570\u89e3\u51b3\uff0c\u5728G4\u5355\u5143\u683c\u8f93\u5165\u516c\u5f0f=text(F4,\"0[dbnum2]\")\uff0c\u70b9\u786e\u5b9a\uff0cF\u5217\u7684\u5176\u4ed6\u6570\u5b57\u4e0b\u62c9\u516c\u5f0f\u5373\u53ef\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/dccb47de450788014d4748f2b18ca608a40f828e.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5927\u5199\u6570\u5b57\u7684\u8f6c\u6362\u4e5f\u53ef\u4ee5\u7528\u5185\u7f6e\u51fd\u6570numbeistring\u89e3\u51b3\uff0c\u9700\u6ce8\u610f\u7684\u662f\uff0cnumberstring\u51fd\u6570\u4f1a\u81ea\u52a8\u5e26\u4e0a\u4e07\u3001\u4edf\u3001\u4f70\u7b49\uff0c\u4f46\u8f6c\u6362\u6210\u5927\u5199\u6570\u5b57\u4f1a\u7f3a\u5931\u5c0f\u6570\u70b9\u540e\u7684\u6570\u5b57\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/a749bb0f94fc508ce7f95a4b01775ddd894cfd8e.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5982\u679c\u8f6c\u6362\u7684\u5927\u5199\u6570\u5b57\u9700\u8981\u8868\u793a\u7684\u662f\u91d1\u989d\uff0c\u53ef\u5728\u516c\u5f0f\u540e\u9762\u52a0\u4e0a\u201c\u5706\u6574\u201d\uff0c\u5373G4\u7684\u516c\u5f0f\u4e3a=NUMBERSTRING(F4,2)&\"\u5706\u6574\"\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e40b3127e7ef2806ee360f6eb840b6f39087f28e.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5982\u679c\u9700\u8981\u7cbe\u786e\u8868\u793a\u591a\u5c11\u89d2\u591a\u5c11\u5206\u7b49\uff0c\u53ef\u5728G4\u8f93\u5165\u516c\u5f0f=IF(ROUND(F4,2)=0,\"\u96f6\u5706\u6574\",IF(F4=1,TEXT(INT(ROUND(ABS(F4),2)),\"[dbnum2]\")&\"\u5706\",\"\")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(F4,2),2),\"[dbnum2]0\u89d20\u5206;;\u6574\"),\"\u96f6\u89d2\",IF(F4^2
    2024-11-22
    1楼
    回复

参与评论

游客评论不支持回复他人评论内容,如需回复他人评论内容请