10 to the Second Power

MWB · Apr 13, 2004

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

Thanks
Mark

Vasant Nanavati · Apr 13, 2004

Type

'102

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

MWB · Apr 13, 2004

Thank You.

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

Mark

Dana DeLouis · Apr 13, 2004

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 · Apr 13, 2004

Dana DeLouis said:
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 · Apr 14, 2004

You could just type:

1, 0, alt-0178

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