Home >Software Tutorial >Computer Software >What should I do if my mobile phone number displays E+10 in the Excel table? How to display all phone numbers in excel?
What should I do if my mobile phone number displays E+10 in the Excel table? How to display all phone numbers in excel?
- WBOYOriginal
- 2024-06-02 10:21:24985browse
When you enter a large number of mobile phone numbers in an Excel sheet, you may encounter a problem where the number appears as E 10. This is because Excel uses scientific notation by default to display numbers that are too long. In order to solve this problem, please read the following content, compiled by php editor Xigua: In the Excel table, you can easily change this setting so that all phone numbers display normally. By following the steps below, you can quickly restore your mobile number to the correct format and easily view and process the data.
1. Right-click all cells filled with numbers and click [Format Cells] in the menu.
2. Change the original [Scientific Notation] to [General], and then confirm.
3. Return to the Excel table to display the phone number normally.
The above is the detailed content of What should I do if my mobile phone number displays E+10 in the Excel table? How to display all phone numbers in excel?. For more information, please follow other related articles on the PHP Chinese website!