Home >Topics >excel >What to do if WPS table numbers are garbled

What to do if WPS table numbers are garbled

藏色散人
藏色散人Original
2019-06-13 10:57:5531299browse

What to do if WPS table numbers are garbled

#What should I do if the numbers in the wps table are garbled?

The steps to solve the problem of garbled data input in the wps form are as follows:

1. First, we switch the computer’s input method to the English input method.

What to do if WPS table numbers are garbled

#2. After switching the input method, we enter a single quote ' in the English input method state into the cell in the table.

What to do if WPS table numbers are garbled

#3. Then enter it again and it will be displayed correctly.

What to do if WPS table numbers are garbled

#4. Or before entering, we right-click in the cell and select "Format Cells".

What to do if WPS table numbers are garbled

5. In the cell format panel, we click 'Text' under the number option and press OK below. This solves the problem of garbled input data in the wps table The problem.

What to do if WPS table numbers are garbled

For more Excel related tutorials, please visit the Excel Basic Tutorial column!

The above is the detailed content of What to do if WPS table numbers are garbled. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn