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

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

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

 

Re: 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 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
>
> 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
>
>

 

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

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)


"Rookie 1st class" <Rookie1stClass@SpamThis> wrote in message
news:...
>² = 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
>> 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
>>
>> 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
>>
>>

 

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

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

"Chip Pearson" wrote:

> 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)
>
>
> "Rookie 1st class" <Rookie1stClass@SpamThis> wrote in message
> news:...
> >² = 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
> >> 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
> >>
> >> 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
> >>
> >>
>
>
>