How do I create a custom number format in Excel using a symbol?
 

I'm setting up a spreadsheet which uses the area of a building (square feet)
and would like to create a custom number format that displays the area using
the symbol for square (ft^2).

How do I create a custom number format in Excel using a symbol?
 

You can either use the character map or input it by yourself by using the
keypad.



Character map:
===========
start, program, Accessaries system tools, Character map. Then you can
find your square sign.
Then use your copy and paste etc method to get the square sign.



Input by your keypad (do not use the number above the alphabet keys on
!@#$%^&*() etc

type ft in a cell (do not hit enter)
then press the Alt key and then using the Keypad type : 0178









"mbuckrell" wrote in message
...
I'm setting up a spreadsheet which uses the area of a building (square
feet)
and would like to create a custom number format that displays the area
using
the symbol for square (ft^2).

How do I create a custom number format in Excel using a symbol?
 

Create a "Custom" format and enclose your text in quotes:

#.#" ft^2"


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mbuckrell" wrote in message
...
I'm setting up a spreadsheet which uses the area of a building (square
feet)
and would like to create a custom number format that displays the area
using
the symbol for square (ft^2).