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

[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

 

[Guest]

² = ALT(253) on my keyboard ▓ = ALT(178). Really getting confused by ALT
character lookups! Can someone shed some light?
Lou

 

[Chip Pearson]

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)

 

[Guest]

Thanks Dave. Good day anytime I learn something new. That is what I get for
referancing an old DOS Manual.
Lou