Re: How do I write a superindex in excel? (e.g. for square meter m2)

  • Thread starter Thread starter Gord Dibben
  • Start date Start date
G

Gord Dibben

ALT + 0178(on the numpad) will give ² after you type the m

If you have a great lot of these to do just go into Format>Cells>Number>Custom
and in the dialog box enter 0"m" then hit ALT + 0178 and OK

Or run this macro on your selected numbers.

Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
'0179 for cubic meters
End Sub


Gord Dibben MS Excel MVP
 
² = ALT(253) on my keyboard ▓ = ALT(178). Really getting confused by ALT
character lookups! Can someone shed some light?
Lou
 
When you enter character codes on the numeric keypad, they should be four
digits long, including leading 0s. ALT+178 is NOT the same as ALT+0178.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Thanks Dave. Good day anytime I learn something new. That is what I get for
referancing an old DOS Manual.
Lou
 
Back
Top