How to change excel phone number to E+10

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!