What should I do if the excel formula is correct but displays garbled characters?
Jun 17, 2020 am 10:53 AM#What should I do if the excel formula is correct but garbled characters are displayed?
The solution to the problem that excel formulas are correct but display garbled characters:
1. Sometimes garbled characters appear when applying formulas in excel tables.
#2. At this time we find the input box of the formula.
#3. Enter an iferror (previous formula, "") in front of the formula.
#4. Press Enter to confirm the formula.
#5. Pull down and update the formula again.
#6. At this time, the garbled characters will be replaced by blank values.
Recommended tutorial: "excel basic tutorial"
The above is the detailed content of What should I do if the excel formula is correct but displays garbled characters?. For more information, please follow other related articles on the PHP Chinese website!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to filter more than 3 keywords at the same time in excel

What should I do if the frame line disappears when printing in Excel?

How to change excel table compatibility mode to normal mode
