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 need make Number Format like scientific notation, but without E nor e. Just classic like this:

alt text

(In latex its 2.3\times10^3)

Maybe Excel doesn't support this format.

(I have on mind Number Format - for hundreds numbers - not in math formula)

share|improve this question

migrated from Mar 29 '10 at 22:52

This question came from our site for professional and enthusiast programmers.

up vote 4 down vote accepted

You could use html. Type this into Notepad

<html>2.34 x 10<sup>-5</sup> + 5.67 x 10<sup>-6</html>

Copy it and, in Excel, Paste Special - Unicode. It will render whatever html you have. You won't be able to edit it in Excel though.

share|improve this answer
Great idea. So in excel: ="<html>"&B6/(10^ROUND(LOG10(ABS(B6));0))&" x 10<sup>"&ROUND(LOG10(ABS(B6));0)&"</sup></html>" then result copy into notepad and copy back to excel. Thanks – Vojtech R. Mar 29 '10 at 20:53

Excel doesn't support that number format.

I think you need to use a formula, like this:

=A1/(10^ROUND(LOG10(ABS(A1)),0))&" x 10^"&ROUND(LOG10(ABS(A1)),0)
share|improve this answer
Nice. But dont produce typographically correct output. Result is "0,9994 x 10^1". How I can replace ^1 by really top index 1? – Vojtech R. Mar 29 '10 at 20:05
You'd have to write a macro if you want to get rid of the ^ and have the exponent be superscript. – devuxer Mar 29 '10 at 20:30
Thanks for help. I cannot select 2 accepted answers. Its weird, because solutions is combination of yours and dkusleika tips. – Vojtech R. Mar 29 '10 at 20:55
@Vojtech, No problem...I think his answer is pretty cool. You can give us both an upvote though if you like. (Click the arrow above the gray number for each question). – devuxer Mar 29 '10 at 21:07

Probably not the best location for this question, but these links might help:

I have used both sites as a reference when dealing with Excel stuff in the past.

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.