Squared symbol

[wethery]

Could someone tell me how you do a little 2 for a squared symbol. i.e
6mm2

--
wethery
------------------------------------------------------------------------
wethery's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26637
View this thread: http://www.excelforum.com/showthread.php?threadid=401483

[Anne Troy]

Select the 2 in the formula bar, and choose Format-->Cells, and check
Superscript.
************
Anne Troy
www.OfficeArticles.com

"wethery" <wethery.1uqlma_...@excelforum-nospam.com> wrote in
message news:wethery.1uqlma_...@excelforum-nospam.com...

[David McRitchie]

ALT+0178 on the numeric keypad, if using a laptop
Fn+ALT+0178 with the blue numeric keypad keys

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"wethery" <wethery.1uqlma_...@excelforum-nospam.com> wrote ...

[MrShorty]

If you just have the text constant "6mm2" in a cell, press F2, highlight
the "2", Format -> Font tab -> Select superscript and press return
twice.

--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22181

[Gord Dibben]

wethery

I would be tempted to use a custom format, thus allowing the number portion to
remain as a number for calculations.

Format>Cell>Number>Custom........enter 0"mm" and using the number pad enter
ALT + 0178

Small macro to do the same job........

Sub sq_MilliMeters()
Selection.NumberFormat = "0""mm" & Chr(178) & """"
'0179 for cubic millimeters
End Sub

Gord Dibben Excel MVP