In our daily using Microsoft Excel, we can often encounter some knotty questions. This tutorial is a guide to tell you how to do it.
Q1:Why these 0 disappeared?
When you enter a string of numbers starting with 0 in the cell, you will find that all the zeros at the beginning are gone.
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Excel-help1.gif)
You can enter “’” single quotation mark in the cell, and then enter the data starting with 0. Or set the number format of the cell to “text”.
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Excel-help-2.gif)
Q2: Why does the cell content become #####?
In fact, this is because the cell is too narrow and the data is not displayed completely. We only need to make the cell a little wider to restore normal display.
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Excel-help3.gif)
Q3: Why these numbers became into 1.23457E+14
Actually, when you enter more than 11 digits in the cell, the data becomes “1.23457E+11
You just need to select the data area that needs to be restored and right-click to choose Format Cells in the list.
Go to custom and type 0, then hit ok.
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/image-65.png)
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/image-66.png)
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Excel-help4-1.gif)
Q4: Why do I enter a formula in the cell but only display the formula, not the outcome I want?
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/image-67.png)
This may be because we set the format of the cell to “text”. We can set the number format of the cell to “General”, then double-click to locate the cell and press Enter to calculate the formula.
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/help-5.gif)
Q5:Where is the Ribbon?
Sometimes, the Ribbon area and all the command buttons or even tabs are gone. How could you find out?
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/image-68.png)
Just click the Ribbon display options button in the upper right corner, and select one which you need.
Q6: The blank cell filling formula shows the wrong value, is there any way to not display it?
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/help-6-1.gif)
If you encounter such a problem, you can use the IFERROR function. Enter =iferror( your formula),””)
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Help-7.gif)
Q7: Why do all the results of the formula I filled in show the same?
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Help-8.gif)
We can go to Formulas and click on the arrow of Calculation Options. Check the first choose “Automatic”
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/image-69.png)
![Excel 2016 Help: Solutions to 7 Common Problems Excel 2016 Help: Solutions to 7 Common Problems](https://www.myofficetricks.com/wp-content/uploads/2021/03/Help-9.gif)
Leave a Reply