Win10 system open excel2010 Chinese garbled how to solve

win10 system open excel2010 Chinese garbled how to solve



























No problem is displayed, use EXCEL to open the garbled situation.

Cause analysis:
This situation is generally a problem with the exported file encoding. In the Simplified Chinese environment, the CSV file opened by EXCEL defaults to ANSI encoding. If the encoding of the CSV file is utf-8, Unicode, etc., the file may be garbled.
Workaround:
1, set the office language environment;

2, start menu - Microsoft office - Microsoft office tools - Microsoft office 2003 language settings, the default language of the Microsoft office application language For “中文(简体)”, this is also the default setting for office 2003;
3, open the CSV file with Notepad, file - save as, select ANSI encoding method:

4, save it After opening this file with EXCEL, there will be no garbled situation.