how do I enter a square feet symbol in excel?

B

Bill Ridgeway

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
 
S

swatsp0p

If you are using this as a calculation entry, use the carat (^) [shifte
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", the
in the formula bar, highlight the '2' and choose Format>Cells from th
main menu. On the Font tab, tick the 'superscript' option and clic
OK. The result will be "16-2- feet" with the -2- as the small, raise
squared sign.

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

HTH

Bruc
 
G

Guest

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²
 
S

swatsp0p

SRS said:
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 th
alt
button while typing in 253)

So your number would look like this: 125²

swatsp0p said:
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 fro 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
This is a good tip (if one can remember the ASCII codes for thes
things). Note that the numbers must be entered through the numeri
keypad, not the top row of numbers on the keyboard for this to work.
Of course, this type of entry is also treated as text and cannot b
used for any calculations.

Bruc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula Help 1
formula for spreadsheet 2
Excel How To Convert Decimal To Inches 2
calculate square feet 4
Convert room dimensions 13' 8" X 9' 2" to square feet 5
Formula 0
locate square root symbol (not words) 4
Excel Count If Formula Question 1

Top