how do I display "meter square" symbol in a formula cell ?

R

Rob van Gelder

Hold down the ALT key and type 0178 on your numeric keypad. That gives you
the superscript two character.
 
G

Gord Dibben

And if you want it as a Custom format.......

In Custom dialog box enter 0"m2"

To enter the 2 above as superscript, enter the m then ALT + 0178

Macro on a button or shortcut key combo.........

Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
End Sub

Note cubic meters is ALT + 0179


Gord Dibben Excel MVP
 
Top