Thread: How Do I Enter A Square Feet Symbol In Excel?

Maybe your like

Register
Help
Forgotten Your Password?
Remember Me?

Forum
- Today's Posts
- FAQ
- Calendar
- Community
  - Groups
- Forum Actions
  - Mark Forums Read
- Quick Links :
What's New?
Members List
Calendar
Forum Rules
Dashboard
Commercial Services

Advanced Search

Forum
Microsoft Office Application Help - Excel Help forum
Excel General
Excel - New Users/Basics
[SOLVED] how do I enter a square feet symbol in excel?

+ Reply to Thread Results 1 to 5 of 5 how do I enter a square feet symbol in excel?

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
- Mark this thread as unsolved…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Linear Mode
- Switch to Hybrid Mode
- Switch to Threaded Mode

09-15-2005, 10:05 AM #1 summerlane Guest
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?
Register To Reply
09-15-2005, 10:31 AM #2 swatsp0p
- View Profile
- View Forum Posts
Forum Expert Join Date 10-07-2004 Location Kentucky, USA MS-Off Ver Excel 2010 Posts 1,545
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

Bruce The older I get, the better I used to be. USA
Register To Reply
09-15-2005, 11:05 AM #3 Bill Ridgeway Guest
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" <[email protected]> wrote in message news:[email protected]... > how do I enter the small '2' as a symbol for 'square feet' in microsoft > excel? >
Register To Reply
09-15-2005, 04:05 PM #4 SRS Guest
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 > View this thread: http://www.excelforum.com/showthread...hreadid=467857 > >
Register To Reply
09-16-2005, 08:56 AM #5 swatsp0p
- View Profile
- View Forum Posts
Forum Expert Join Date 10-07-2004 Location Kentucky, USA MS-Off Ver Excel 2010 Posts 1,545
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 > View this thread: http://www.excelforum.com/showthread...hreadid=467857 > > This is a good tip (if one can remember the ASCII codes for these things). Note that the numbers must be entered through the numeric 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 be used for any calculations. Bruce
Register To Reply