W
wethery
Could someone tell me how you do a little 2 for a squared symbol. i.e
6mm2
6mm2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
Select the 2 in the formula bar, and choose Format-->Cells, and check
Superscript.
************
Anne Troy
www.OfficeArticles.com
Superscript.
************
Anne Troy
www.OfficeArticles.com
D
David McRitchie
ALT+0178 on the numeric keypad, if using a laptop
Fn+ALT+0178 with the blue numeric keypad keys
Fn+ALT+0178 with the blue numeric keypad keys
M
MrShorty
If you just have the text constant "6mm2" in a cell, press F2, highligh
the "2", Format -> Font tab -> Select superscript and press retur
twice
the "2", Format -> Font tab -> Select superscript and press retur
twice
G
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
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