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)

0

3 Answers 3

6

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
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)
5
  • 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, 2010 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, 2010 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, 2010 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, 2010 at 21:07
  • you can use Unicode superscript ⁰¹²³⁴⁵⁶⁷⁸⁹ to have a top number instead of ^
    – phuclv
    Apr 27, 2019 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.

You must log in to answer this question.

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