当前位置：你问我答网 > 社会

excel如何将数字自动转换成大写中文

2022-08-02 社会 56阅读
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,"零"),9,"玫"),8,"捌"),7,"柒"),6,"陆"),5,"伍"),4,"肆"),3,"叁"),2,"贰"),1,"壹")
声明：你问我答网所有作品（图文、音视频）均由用户自行上传分享，仅供网友学习交流。若您的权利被侵害，请联系fangmu6661024@163.com
0

猜你喜欢