View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rookie 1st class Rookie 1st class is offline
external usenet poster
 
Posts: 152
Default How do I write a superindex in excel? (e.g. for square meter m

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

"Gord Dibben" wrote:

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 FormatCellsNumberCustom
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

On Thu, 7 Dec 2006 13:49:00 -0800, gleba
wrote:

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