Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

I want to see big numbers in same power of scientific notation in microsoft excel

for example, I want to see these numbers in excel cells

1.23E+7          1.45E+10          1.36E+12

as below:

1.23E+7        1453.11E+7      136445.11E+7

(all with E+7 power)

share|improve this question

To my knowledge you cannot fix the power using the default formatting (though I'm happy to learn I'm wrong). What you can do instead: use a formula next to it to convert it to your format:

share|improve this answer
in my case, with greek international settings i.e. comma for decimal separator, this was the only thing that worked : =TEXT(A1*10^7;"0,00") & "E+7" – hello_earth Jan 30 at 15:42

No, not in Excel and still retaining it as a numeric value. But, if you are willing to accept "E+n" where n is a multiple of 3 you can use custom number formats such as:


Each comma appearing after the decimal point shows the output divided by 1000. Using custom number formats has the advantage of keeping the real numeric values unmodified and suitable for further calculations.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.