一个表格数据设置没弄好,就容易出现E+的乱码情况,这里分享下解决方法。
1、首先打开Excel表格,填写身份证号数据,可以看到它自动跳转为E+乱码形式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4a431d82831bf790529922d19e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中该项数据列或者选中需要修改的数据单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1b4c510fd9f9d72a19e0e18dc62a2834359bbb9e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击鼠标右键,在弹出窗口中选择【设置单元格格式】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/342ac65c10385343774b76b18113b07ecb80889e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在弹出的窗口中,点击【数字】选项,这是由于本身输入的号码为数字。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a2cc7cd98d1001e99cb8e59faa0e7bec55e7979e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、将下方的【常规】更改为【自定义选项】,也可以选择特殊中的邮政编号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b292df5e0fe99257f8898c026a85edf8cb1719e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、最后选中自定义选项之后,下拉列表选择【000000】选项,查看上方的示例可以看到完整的号码,点击【确定】即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100571809b1608b4710b8122f9e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)