How did the excel phone number become E 10
The scientific notation in Excel will be expressed as: (with decimal point) number E plus number; There is an E in the phone number. Obviously, Excel treats the phone number as a number and automatically uses scientific notation to represent . As long as the format is set, the complete phone number can be displayed.
Recommended: "Excel Basic Tutorial"
The solution is as follows:
1. The phone number is displayed in scientific notation :
2. Select the cell, right-click, and set the cell format:
3. Select Classified as "General":
4. Confirm to return to Excel and the phone number will be displayed normally:
For more related tutorials, please pay attention to PHP中文网!
The above is the detailed content of How to change excel phone number to E+10. For more information, please follow other related articles on the PHP Chinese website!
