作者Ryu3y3s (3y3s)
看板Office
标题Re: [问题] google sheet 数字转中文大写
时间Mon Apr 4 19:04:53 2022
※ 引述《elrice2010 (玉米猫)》之铭言：
: 参考W大的公式做了一点修改，测试都没问题，提供给大家~
: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(B31,"0
: 亿0仟0佰0拾0万0仟0佰0拾0元"),"1","壹"),"2","贰"),"3","参"),"4","肆"),"5","伍
: "),"6","陆"),"7","柒"),"8","捌"),"9","玖"),"0","零")
: 感谢W大拯救了我的肝。
: 请收下我的膝盖。
: ※ 引述《windknife18 (windknife18)》之铭言：
: : 第一次玩 Google Sheet，可以用以下暴力法来解
: : =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUB
: : STITUTE(SUBSTITUTE(substitue(SUBSTITUTE(TEXT(A2,"[DBNUM2]0
: : 亿0仟万0佰万0拾万0万0仟0佰0拾0元"),"1","壹"),"2","贰"),"3","参"),"4","肆
: : "),"5","伍"),"6","路"),"7","柒"),"8","捌"),"9","玖"),"0","零")
根据 e大 和 w大 的式子写程式生成了比较接近一般中文用法的版本
例如 10001 会变成 新台币壹万零壹元整
https://pastebin.com/rxzW0hR1
将里面的 F44 替换成要用的储存格就好
如果有 bug 烦请告知一下
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 36.229.232.223 (台湾)
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Office/M.1649070296.A.73B.html
1F：推 newacc: 4657个字元的公式必须推XD 04/05 21:38