# how do I enter a square feet symbol in excel?

• 09-15-2005, 10:05 AM
summerlane
how do I enter a square feet symbol in excel?
how do I enter the small '2' as a symbol for 'square feet' in microsoft excel?

• 09-15-2005, 10:31 AM
swatsp0p
If you are using this as a calculation entry, use the carat (^) [shifted number 6] e.g. "equals 4 squared" would be =4^2

If it is a text entry, as in "16 square feet", enter "162 feet", then in the formula bar, highlight the '2' and choose Format>Cells from the main menu. On the Font tab, tick the 'superscript' option and click OK. The result will be "16-2- feet" with the -2- as the small, raised squared sign.

Of course both of these apply to any power as well.

HTH

Bruce
• 09-15-2005, 11:05 AM
Bill Ridgeway
Re: how do I enter a square feet symbol in excel?
Highlight the 2
Click on <Format><Cells><Superscript><OK>
Job done

Although you will see the 2 as superscript in the cell in the edit line (if
you don't edit directly in the cell) it will appear as ordinary text. Yet
another anomaly from Mr Gates.

Regards.

Bill Ridgeway
Computer Solutions

"summerlane" <summerlane@discussions.microsoft.com> wrote in message
news:A17A561F-0DAB-4804-A769-45D0D41574B7@microsoft.com...
> how do I enter the small '2' as a symbol for 'square feet' in microsoft
> excel?
>

• 09-15-2005, 04:05 PM
SRS
Re: how do I enter a square feet symbol in excel?
One other option is to use the shortcut code which is available in most
applications.

The "code" for the small 2 is: Alt + 253 (be sure to hold down the alt
button while typing in 253)

So your number would look like this: 125²

"swatsp0p" wrote:

>
> If you are using this as a calculation entry, use the carat (^) [shifted
> number 6] e.g. "equals 4 squared" would be =4^2
>
> If it is a text entry, as in "16 square feet", enter "162 feet", then
> in the formula bar, highlight the '2' and choose Format>Cells from the
> main menu. On the Font tab, tick the 'superscript' option and click
> OK. The result will be "16-2- feet" with the -2- as the small, raised
> squared sign.
>
> Of course both of these apply to any power as well.
>
> HTH
>
> Bruce
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
>
>

• 09-16-2005, 08:56 AM
swatsp0p
Quote:

Originally Posted by SRS
One other option is to use the shortcut code which is available in most
applications.

The "code" for the small 2 is: Alt + 253 (be sure to hold down the alt
button while typing in 253)

So your number would look like this: 125²

"swatsp0p" wrote:

>
> If you are using this as a calculation entry, use the carat (^) [shifted
> number 6] e.g. "equals 4 squared" would be =4^2
>
> If it is a text entry, as in "16 square feet", enter "162 feet", then
> in the formula bar, highlight the '2' and choose Format>Cells from the
> main menu. On the Font tab, tick the 'superscript' option and click
> OK. The result will be "16-2- feet" with the -2- as the small, raised
> squared sign.
>
> Of course both of these apply to any power as well.
>
> HTH
>
> Bruce
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101