Inventory of several common basic problems in Excel: numbers become 1.23457E+14

In Excel tabulation, we encounter some strange problems every few days. Here, Xiao Wang specially sorted out these problems and solutions and shared them with everyone.

1. Cell content becomes ####Problem: After opening the table, it is found that some of the contents have become ####.

Solution: In fact, this is because the cells are too small and the data is not displayed completely. We just need to widen the cells a bit to restore the normal display.

2. When the number becomes 1.23457E+14 Problem: When more than 11 digits are entered in the cell, the data becomes "1.23457E+11".

Solution: Select the data area to be restored,"right-click"-"Set Cell Format"-"Custom", and then enter "0" to confirm the normal display. (Hint: More than 15 people can't be restored!)

3. The input 0 is missing. Problem: The "0" entered at the beginning of the cell will disappear.

Solution: We can enter "'" single quotes in the cell, and then enter the data starting with 0. Or set the number format to Text.

4. The function area is missing. Problem: The tabs and all the command buttons are not displayed. What's going on?

Solution: We simply click on the up arrow in the upper right corner "Ribbon Display Options" and select "Show Tabs and Commands."

5. Input formula shows wrong value Question: The input formula obviously has no problem, but why does the result show error?

Solution: This may be because the symbol in our formula is Chinese. You can switch the symbols in the formula to English symbols.

6. Input formula to display formula Question: After inputting formula, shouldn't it be operated? Why is formula still displayed?

Solution: This may be caused by formatting cell numbers to "text." We can set the number format of the cell to "General," then double-click to enter the cell, enter to calculate the formula.

7. Fill formulas all show the same results Question: Why do all the results of my fill formulas show the same results?

Solution: We can enter the "calculation" in the "formula" and set the "calculation option" to "automatic" to return to normal.

8, hide error value problem: blank cell fill formula shows error value, what way can not show?

Solution: iferror function is specifically to solve the wrong value of the formula, we can use the formula = IFERROR (your formula,""), solve this problem.

This article comes from Weixin Official Accounts: Word Alliance (ID: Wordlm123), author: Wang Qi