Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 2000000 as 2.0E+6. However I want this 20.0E+5, or 0.2E+7.

How it is possible to change the number format?

share|improve this question
up vote 2 down vote accepted

Set the number format to the Custom category, and enter 00.0E+0. You can change the 00.0 before the decimal point in order to customize the scientific format. For example, this number format would show 20.0E+5, but if you change it to 0.0E+0, it will show as 2.0E+6.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .