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

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 stackoverflow.com 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:

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.

share|improve this answer

You must log in to answer this question.

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