In microsoft excel, I want to use the scientific format for a number. However the built-in format will the number with one digit in the left of the point.
For example, it shows
2.0E+6. However I want this
How it is possible to change the number format?