# Scientific notation in Excel

I need make Number Format like scientific notation, but without E nor e. Just classic like this:

(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)

-

## migrated from stackoverflow.comMar 29 '10 at 22:52

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

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.

-
– dkusleika Mar 29 '10 at 20:09
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)

-
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:

http://peltiertech.com/Excel/NumberFormats.html

http://www.ozgrid.com/Excel/CustomFormats.htm

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

-