3

I need make a number format similar to scientific notation, but without E nor e. Just classic like this:

alt text

(In latex it's 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.com Mar 29 '10 at 22:52

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

5

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.

2

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
  • you can use Unicode superscript ⁰¹²³⁴⁵⁶⁷⁸⁹ to have a top number instead of ^ – phuclv Apr 27 at 8:03
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.