智者总要千虑
高粉答主
2021-06-21
·
说的都是干货,快来关注
知道顶级答主
回答量:7.9万
采纳率:88%
帮助的人:1.4亿
关注
Excel中B列有数据如下图所示,将之设置为百分比格式:
![](https://iknow-pic.cdn.bcebos.com/55e736d12f2eb938811c1693c5628535e5dd6f59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
按下Alt+F11,打开VBA编辑界面,双击左侧的源数据所在工作表,如下图所示:
![](https://iknow-pic.cdn.bcebos.com/9a504fc2d5628535fb91be4080ef76c6a7ef6359?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
输入代码如下图所示:
Sub 鱼木混猪()
Range("B1:B4").NumberFormatLocal = "0.00%"
End Sub
![](https://iknow-pic.cdn.bcebos.com/2e2eb9389b504fc2c92edc64f5dde71190ef6d59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
然后点击 “运行子程序”按钮,如下图所示:
![](https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b50548e8c339535e5dde7116e59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
关闭VBA编辑界面,返回Excel中,就可以看到B列单元格格式变成了百分比格式,如下图所示:
![](https://iknow-pic.cdn.bcebos.com/b8389b504fc2d5629879bc8cf71190ef76c66c59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
收起
为你推荐: