分享兴趣，传播快乐，增长见闻，留下美好!亲爱的您，这里是LearningYard学苑今天小编为大家带来[小高分享（3）：一招搞定Excel表格数据乱码问题]欢迎您的访问!Share interest，spread happiness，i。
ncrease knowledge，and leave beautiful.Dear，this is the LearingYard Academy!Today，the editor brings the
“Xiao Gaos sharing（3）One trick to solve the Excel table data garbled problem。”Welcome to visit!
1、问题简介：Introduction to the problem:在用Excel表格收集数据信息（如身份证号码、电话号码、银行卡号等）时，常常会出现输入长串数字后变成乱码的情况重新输入一遍，还是乱码。
这是一个很普遍的问题，让很多经常编辑表格的朋友感到头疼小编本人也是被烦恼过很多次，终于摸索出解决的方法下面就以身份证号码为例，将方法分享给大家When using Excel to collect data information (such as ID card number, telephone number, bank card number, etc.), it often appears that a long string of digits becomes garbled. Enter it again, its still garbled. This is a very common problem, which makes many friends who often edit tables feel headache. Xiaobian myself has also been troubled many times, and finally found a solution. The following will take the ID card number as an example to share the method with you.
2、具体操作：Specific operation：首先，打开需要编辑的Excel表格，选中变成乱码的数据First, open the Excel table you want to edit and select the data that has become garbled.。
接着，在数据最前面输入一个引号注意：需要在输入法为英文的情况下输入引号Next, enter a quotation mark at the beginning of the data. Note: You need to enter quotes when the input method is in English.。
最后，再点击回车即可Finally, hit Enter again.当有一竖列乱码数据时，也可以用另外一种方法：设置单元格格式When there is a column of garbled data, you can also use another method: set the cell format.。
首先，将身份证号这一竖列全部选中右键点击设置单元格格式First, select all the vertical columns of the ID number. Right click to format the cell.。
然后点击【分类】中的【数值】，将小数位数改为0即可Then click [Value] in [Category] and change the number of decimal places to 0.。
3、方法总结：Method summary:当只有一个数据出现问题（变成乱码）时，可以直接在数据前加上一个英文引号；当需要编辑一竖列数据时，就需要将单元格格式设置为数值，并将小数位数改完0When only one data is faulty (it becomes garbled), you can directly add an English quotation mark before the data. When you want to edit a column of data, you need to format the cells to numeric values and change the number of decimal places to 0.。
今天的分享就到这里了，如果您对文章有独特的想法，欢迎给我们留言让我们相约明天，祝您今天过得开心快乐!Thats all for todays sharing.If you have a unique ideaabout the article，。
please leave us a message，and let usmeet tomorrow.I wish you a nice day!本文由learningyard新学苑原创，如有侵权，请联系我们。
部分内容参考于bilibili、百度翻译来源：百度翻译文案＆排版：高杰审核：许江越
亲爱的读者们，感谢您花时间阅读本文。如果您对本文有任何疑问或建议，请随时联系我。我非常乐意与您交流。
发表评论:
◎欢迎参与讨论，请在这里发表您的看法、交流您的观点。