Scientific notation in Excel

Question

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)

dkusleika · Answer 1 · 2010-03-29 20:08:57Z

up vote 2 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.

answered Mar 29 '10 at 20:08

	See also dailydoseofexcel.com/archives/2005/02/23/html-in-cells-ii – 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

feedback

DanM · Answer 2 · 2010-03-29 19:24:20Z

up vote 2 down vote

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)

answered Mar 29 '10 at 19:24

DanM
525315

	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. – DanM 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). – DanM Mar 29 '10 at 21:07

feedback

Bradley Mountford · Answer 3 · 2010-03-29 19:25:30Z

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.

migrated from stackoverflow.com Mar 29 '10 at 22:52