EXCEL表格中我的日期变成了###
发布网友
发布时间：15小时前
共1个回答
热心网友
时间：16小时前
EXCEL表格中我的日期变成了########，改回来的具体步骤为：
所需工具：excel。
一、首先，打开Excel表格软件，可以看到此时在工作区输入日期，日期就会全部变成“#”。
/iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1d4c4924e592c11dfa9ecce7f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1d4c4924e592c11dfa9ecce7f?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/0b7b02087bf40ad1d4c4924e592c11dfa9ecce7f"/>
二、然后，在Excel软件主界面上方选择“数据”，在“数据”菜单下找到“分列”，点击“分列”。
/iknow-pic.cdn.bcebos.com/00e93901213fb80e74cf357a38d12f2eb93404"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/00e93901213fb80e74cf357a38d12f2eb93404?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/00e93901213fb80e74cf357a38d12f2eb93404"/>
三、在对话窗中选择勾选“分隔符号”，设置使用分隔符号。
/iknow-pic.cdn.bcebos.com/a8014c086e061d95b833629575f40ad162d9ca22"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a8014c086e061d95b833629575f40ad162d9ca22?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/a8014c086e061d95b833629575f40ad162d9ca22"/>
四、然后，在下一个窗口中勾选“其他”选项，点击下一步，进入下一步操作。
/iknow-pic.cdn.bcebos.com/ca1349540923dd546215f2c5df09b3de9c82483c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/ca1349540923dd546215f2c5df09b3de9c82483c?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/ca1349540923dd546215f2c5df09b3de9c82483c"/>
五、在步骤3的操作窗口中选择“日期”，点击下一步，即可完成。
/iknow-pic.cdn.bcebos.com/314e251f95cad1c8ecf5a98a713e6709c83d51d4"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/314e251f95cad1c8ecf5a98a713e6709c83d51d4?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/314e251f95cad1c8ecf5a98a713e6709c83d51d4"/>
六、最后，返回到Excel表格软件操作界面中，即可看到，日期显示正常。
/iknow-pic.cdn.bcebos.com/b3119313b07eca809c3b6c4a9f2397dda1448365"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b3119313b07eca809c3b6c4a9f2397dda1448365?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/b3119313b07eca809c3b6c4a9f2397dda1448365"/>
热心网友
时间：15小时前
EXCEL表格中我的日期变成了########，改回来的具体步骤为：
所需工具：excel。
一、首先，打开Excel表格软件，可以看到此时在工作区输入日期，日期就会全部变成“#”。
/iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1d4c4924e592c11dfa9ecce7f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1d4c4924e592c11dfa9ecce7f?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/0b7b02087bf40ad1d4c4924e592c11dfa9ecce7f"/>
二、然后，在Excel软件主界面上方选择“数据”，在“数据”菜单下找到“分列”，点击“分列”。
/iknow-pic.cdn.bcebos.com/00e93901213fb80e74cf357a38d12f2eb93404"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/00e93901213fb80e74cf357a38d12f2eb93404?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/00e93901213fb80e74cf357a38d12f2eb93404"/>
三、在对话窗中选择勾选“分隔符号”，设置使用分隔符号。
/iknow-pic.cdn.bcebos.com/a8014c086e061d95b833629575f40ad162d9ca22"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a8014c086e061d95b833629575f40ad162d9ca22?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/a8014c086e061d95b833629575f40ad162d9ca22"/>
四、然后，在下一个窗口中勾选“其他”选项，点击下一步，进入下一步操作。
/iknow-pic.cdn.bcebos.com/ca1349540923dd546215f2c5df09b3de9c82483c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/ca1349540923dd546215f2c5df09b3de9c82483c?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/ca1349540923dd546215f2c5df09b3de9c82483c"/>
五、在步骤3的操作窗口中选择“日期”，点击下一步，即可完成。
/iknow-pic.cdn.bcebos.com/314e251f95cad1c8ecf5a98a713e6709c83d51d4"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/314e251f95cad1c8ecf5a98a713e6709c83d51d4?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/314e251f95cad1c8ecf5a98a713e6709c83d51d4"/>
六、最后，返回到Excel表格软件操作界面中，即可看到，日期显示正常。
/iknow-pic.cdn.bcebos.com/b3119313b07eca809c3b6c4a9f2397dda1448365"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b3119313b07eca809c3b6c4a9f2397dda1448365?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/b3119313b07eca809c3b6c4a9f2397dda1448365"/>
