What should I do if Excel is garbled when I open it? How to recover if Excel is garbled when I open it?

What should I do if the Excel file is garbled when I open it? Excel is a table tool used by many users. Here it can help users solve many calculation problems. However, many users find that their excel files are garbled. Then let this site help users Let’s take a closer look at how to recover garbled characters when opening Excel. How to recover garbled characters when opening Excel 1. When Excel opens a document in csv format, garbled characters appear. 2. The CSV file with garbled characters is opened through Notepad. 3. After opening it with Notepad, you will find a bunch of garbled characters. Click File---Save As.

4. Select ANSI format in the pop-up save dialog box.

5. After the setting is completed, save the file and open it in excel. As you can see, the document can be displayed normally.

The above is the detailed content of What should I do if Excel is garbled when I open it? How to recover if Excel is garbled when I open it?. For more information, please follow other related articles on the PHP Chinese website!