发布网友 发布时间:2024-10-23 08:17
共1个回答
热心网友 时间:2分钟前
EXCEL表格日期输入后和自己输入的不一样是因为单元格格式设置不正确,具体解决步骤如下:
1、首先我们打开电脑里的excel软件,选择单元格里面输入日期格式,2017/10/12,再点击回车按钮,之后相应的单元格就会显示出5位数字,理论上应该是日期,但实际上却变成了数字。
/iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1113451592c11dfa8ecce8c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1113451592c11dfa8ecce8c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1113451592c11dfa8ecce8c"/>
2、这个时候我们将要输入日期的单元格都选中,鼠标右键点击一下。
/iknow-pic.cdn.bcebos.com/2cf5e0fe9925bc31b45290f250df8db1cb137049"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/2cf5e0fe9925bc31b45290f250df8db1cb137049?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/2cf5e0fe9925bc31b45290f250df8db1cb137049"/>
3、之后在选项卡中点击设置单元格格式。
/iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100abfe694b7c8b4710b9122f7d"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100abfe694b7c8b4710b9122f7d?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100abfe694b7c8b4710b9122f7d"/>
4、之后我们可以看到当前区域的单元格格式,如图可以看到是数字格式。
/iknow-pic.cdn.bcebos.com/eac4b74543a98226828fba4d8482b9014a90eb0a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/eac4b74543a98226828fba4d8482b9014a90eb0a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/eac4b74543a98226828fba4d8482b9014a90eb0a"/>
5、然后我们在里面选择日期选项,在里面选择一个日期的格式,点击确定即可。
/iknow-pic.cdn.bcebos.com/9358d109b3de9c82242d68e56281800a19d84314"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9358d109b3de9c82242d68e56281800a19d84314?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/9358d109b3de9c82242d68e56281800a19d84314"/>
6、之后我们可以看到日期就不会显示成数字啦,会按照上一步的设置显示相应的日期格式。
/iknow-pic.cdn.bcebos.com/42166d224f4a20a4cee1adad9e529822730ed0d9"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/42166d224f4a20a4cee1adad9e529822730ed0d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/42166d224f4a20a4cee1adad9e529822730ed0d9"/>
7、我们还可以换一个时间格式,就会将所有的时间变成需要的时间格式了。
/iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fbc799c978414a20a44623dc2e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fbc799c978414a20a44623dc2e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fbc799c978414a20a44623dc2e"/>