1、首先我们选择要编辑的区域。
![](https://iknow-pic.cdn.bcebos.com/b3119313b07eca80fdcfcd029f2397dda0448309?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击菜单栏中的“数据”——“分列”。
![](https://iknow-pic.cdn.bcebos.com/1c950a7b02087bf45e9ba30cfcd3572c10dfcfe4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、弹出窗口点击下一步。
![](https://iknow-pic.cdn.bcebos.com/738b4710b912c8fc3ab60128f2039245d788218a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、继续点击“下一步”。
![](https://iknow-pic.cdn.bcebos.com/5d6034a85edf8db1056f8b810723dd54574e7496?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在数据格式中我们选择“日期”——“YMD”。
![](https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee3476f8fc23f5e0fe98257efb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、点击完成后,我们回到表中,发现各种形式的日期已经统一规范。
![](https://iknow-pic.cdn.bcebos.com/1b4c510fd9f9d72a1fdae7f8da2a2834359bbb9d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在EXCEL表格里,去掉日期后面的00:00:00,只需要简单三个步骤就能实现,具体操作方法如下:
工具/原料:机械革命S3 Pro、Windows10、Excel 20212108。
1、单击右键:
打开EXCEL表格,选中带有时间的单元格,点击鼠标右键,选择“设置单元格格式”。
![](https://iknow-pic.cdn.bcebos.com/9345d688d43f879428624fb8c01b0ef41ad53a82?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、设置格式:
弹出窗口,左侧点击“日期”,右侧在类型下方选择格式。
![](https://iknow-pic.cdn.bcebos.com/c2fdfc039245d6885e9fb532b6c27d1ed31b2482?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、查看结果:
点击确定,单元格内日期后面的“00:00:00”批量去除。
![](https://iknow-pic.cdn.bcebos.com/4610b912c8fcc3ce455dcea58045d688d53f2082?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)