How can I show exponents in numerical form
 

I need to show exponents written numerically, like 2 to the 3rd power. Is
there any way to do this?

How can I show exponents in numerical form
 

The value in the cell has to be Text (not a real number, not a formula).

So preformat the cell as text and type 23 into that cell
(or add a leading apostrophe '23)
select the 3 in the formulabar
format|cells|check Superscript.

This won't make the value 8--it'll be just text that looks pretty.

This technique won't work with real numbers. If you really wanted it to
evaluate to 8, you could use:
=2^3

If you have lots of these to do...

Try John Walkenbach's addin:
http://j-walk.com/ss/excel/files/supersub.htm

Tanjia wrote:

I need to show exponents written numerically, like 2 to the 3rd power. Is
there any way to do this?

--

Dave Peterson

How can I show exponents in numerical form
 

You can custom format the cells.

Type a zero(0) then Alt + 0179 on the numpad to get 2³

For 3² use Alt + 0178


Gord Dibben MS Excel MVP

On Tue, 10 Apr 2007 07:38:00 -0700, Tanjia
wrote:

I need to show exponents written numerically, like 2 to the 3rd power. Is
there any way to do this?