原因:通过其它地方复制粘贴过来的日期或数字,在excel内默认为文本格式或特殊所导致的,解决方法如下:
所需材料:Excel。
一、以下面这张表为例,要更改时间日期的格式,这时选中所有日期,右键点击,菜单内点击“设置单元格格式”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/500fd9f9d72a6059f08fb86d2734349b033bba2e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、格式窗口内选择日期内的一个格式,点击格式窗口“确定”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f904c70c1e2a2dd42a2934a4f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、这时能够看到,格式并未改变,需要手动双击一下单元格才能够改,这时可以点击“数据”选项下的“分列”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7db1f959bde00baa1cd112aad?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、分列第一步勾选“分隔符号”,点击“下一步”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c22bacbe5c01f41bd5ad6e393d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
五、分列第二步勾选“Tab键”,点击“下一步”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42166d224f4a20a4f9d365b09f529822730ed0fc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
六、分列第三步勾选“常规”,点击“完成”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f3d3572c11dfa9ec24a70f606dd0f703918fc138?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
七、这时就可以把所选日期全部批量改变格式,而不再需要手动逐个点击改变。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2f738bd4b31c870136aeea91287f9e2f0708ffa9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)