Engineering notation of numbers 1,2X103.. with 3 a superscript????

[Kmil]

Is it possible to create a custom format of numbers in order to have
1X103?... 3 is the superscript...

I need it to graph a logarithmic y axis....

thanx for ur help..

 

[Gord Dibben]

Custom format of 0"x"00 and Alt + 0179

Returns 1x10³ from 110


Gord Dibben MS Excel MVP

 

[TomPl]

Your question is not at all clear.

You can use the formula =1*10^3.
You can edit the contents of a cell by selecting the 3 then: format cells -
font - superscript.
You can format the number to scientific: format cells - number - scientific

Don't know if this helps.

 

[Kmil]

Thank u very much Gord Dibben... i´m afraid i couldn´t do what u
suggested... what about Alt + 179 ,... do i have to type this after 0"x"00 ??
or just press them together???

thanx again

 

[Rick Rothstein \(MVP - VB\)]

You hold down the Alt key and type 0179 (the zero is important) on the
number pad (not the main keyboard). And yes, you type it after the 0"x"00.

Rick