可以设计公式。若A列为你的数据,在B1中输入公式如下:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,"零"),9,"玖"),8,"捌"),7,"柒"),6,"陆"),5,"伍"),4,"肆"),3,"叁"),2,"贰"),1,"壹")
输完后下拉即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c6e94863785d6277f9f2ff896?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
另,设置单元格格式,可以变成大写,但里面有“亿”“万”等达不到你的要求,我做的这版完全符合你的要求。
记得采纳哟!!!!!