从文档中复制身份证号码到表格中，号码都变成E+乱码，怎么处理？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在<span style="color: black;">平常</span>工作中，有时从别的<span style="color: black;">地区</span>复制身份证号码到Excel表格中，身份证就莫名其妙地<span style="color: black;">表示</span>这种E+乱码，这种<span style="color: black;">状况</span>该<span style="color: black;">怎样</span><span style="color: black;">处理</span>呢！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/bb01f01ab3f24bf1a1d4b7c491f2b119~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=MY8rLZ9Oxk85kZZe2Rk6rX02%2B1U%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">首要</span>，要<span style="color: black;">晓得</span>表格对超出11位的数字会以<strong style="color: blue;">科学计数法</strong><span style="color: black;">暗示</span>，<span style="color: black;">针对</span>15位以外的数字，超出部分会以零<span style="color: black;">表示</span>，就算你点击任意一个乱码，后面的三位数字还是<span style="color: black;">表示</span>零，和我<span style="color: black;">一块</span><span style="color: black;">处理</span>吧。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/bd1ec7e22d8443dbb71141346d536639~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=1Kf7P34Q6O%2B8lpuXYV8irUVjjKU%3D" style="width: 50%; margin-bottom: 20px;"></div><strong style="color: blue;"><span style="color: black;">第1</span>步：先选中空白单元格</strong>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/05304594971d44299285cbbbfaaf368a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=sAVS%2BD23aYGxV%2Fd%2BdV2DvwwaD8o%3D" style="width: 50%; margin-bottom: 20px;"></div><strong style="color: blue;">第二步：设置为文本格式</strong>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">按快捷键【Ctrl+1】调出单元格格式，在数字下，点击<strong style="color: blue;">文本</strong>，最后确定</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/9063ad7c95b641c9811a2d93775483aa~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=aJSMKgbb7Ug7e9jLuP%2Bf7uXZSjw%3D" style="width: 50%; margin-bottom: 20px;"></div><strong style="color: blue;">第三步：在word文档中复制身份证</strong>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/a318344e2b31442aaf86b2d0218f1659~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=Qa2%2FUqAJohdNWRovVIPfFnXjHqA%3D" style="width: 50%; margin-bottom: 20px;"></div><strong style="color: blue;">第四步：粘贴为文本</strong>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">当你从word文档中复制好表格之后，绝对绝对不<span style="color: black;">能够</span>直接按Ctrl+V进行粘贴，而是将鼠标放在单元格上，<span style="color: black;">而后</span>鼠标右键，点击<strong style="color: blue;">只粘贴为文本</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/bda1838a29bf4710ada8dd712b549cde~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=zkN83jk30j6W9rRJajvmUX8BYKE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">此时的身份证号码，就<span style="color: black;">能够</span>正常<span style="color: black;">表示</span>出来了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/915c74cea7f74dd4b2f836fbfa202c44~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728386326&x-signature=DGEMD1v0OMU4jp9zToNeh8ozqhY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">身份证变成E+乱码，学会的小伙伴点赞，支持一下吧！！</p>
回顾历史，我们感慨万千；放眼未来，我们信心百倍。
页:
[1]