分享兴趣，传播快乐，

增长见闻，留下美好!

亲爱的您，这里是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 Gao's 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, it's 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:

当只有一个数据出现问题（变成乱码）时，可以直接在数据前加上一个英文引号；当需要编辑一竖列数据时，就需要将单元格格式设置为数值，并将小数位数改完0。

When 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.

今天的分享就到这里了，

如果您对文章有独特的想法，

欢迎给我们留言。

让我们相约明天，

祝您今天过得开心快乐!

That's all for today's 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、百度

翻译来源：百度翻译

文案＆排版：高杰

审核：许江越