10 to the Second Power

[MWB]

I need to show 10 to the second power in a spread sheet. Any ideas?

Thanks
Mark

 

[Vasant Nanavati]

Type

'102

into a cell. Highlight the 2 in the formula bar and, use Format | Cells |
Font | Effects | Superscript.

 

[MWB]

Thank You.


There's a very nice lady at my office that's going to give me a hug.

Mark

 

[Dana DeLouis]

If using a formula, a very poor workaround might be something like this. The
178 being the small 2 in Arial Font.

=10 & CHAR(178)

 

[MWB]

If using a formula, a very poor workaround might be something like this. The
178 being the small 2 in Arial Font.

=10 & CHAR(178)

Thanks for your reply Dana. So far it's not in a formula but it will be.

Mark

 

[Dave Peterson]

You could just type:

1, 0, alt-0178

(although it's easier to see what's happening in Dana's suggestion.