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
On Fri, 28 Jan 2005 22:24:22 +1300, "Rob van Gelder"
wrote:
Hold down the ALT key and type 0178 on your numeric keypad. That gives you
the superscript two character.
|