Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

add comment

3 Answers 3

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.