PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average.

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

 
 
Gord Dibben
Guest
Posts: n/a
 
      8th Dec 2006
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 <(E-Mail Removed)>
wrote:

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


 
Reply With Quote
 
 
 
 
=?Utf-8?B?Um9va2llIDFzdCBjbGFzcw==?=
Guest
Posts: n/a
 
      8th Dec 2006
² = 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 <(E-Mail Removed)>
> wrote:
>
> >How do I write a superindex in excel? (e.g. for square meter m2) Thank you

>
>

 
Reply With Quote
 
 
 
 
Chip Pearson
Guest
Posts: n/a
 
      8th Dec 2006
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:(E-Mail Removed)...
> = 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
>> <(E-Mail Removed)>
>> wrote:
>>
>> >How do I write a superindex in excel? (e.g. for square meter m2) Thank
>> >you

>>
>>



 
Reply With Quote
 
=?Utf-8?B?Um9va2llIDFzdCBjbGFzcw==?=
Guest
Posts: n/a
 
      11th Dec 2006
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:(E-Mail Removed)...
> >² = 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
> >> <(E-Mail Removed)>
> >> wrote:
> >>
> >> >How do I write a superindex in excel? (e.g. for square meter m2) Thank
> >> >you
> >>
> >>

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autocorrect in Excel - "m2" (square meter notification) Snoopy Microsoft Excel Discussion 6 15th Feb 2007 10:08 AM
Small square icon w/ red square, green circle & blue triangle insi =?Utf-8?B?Um9iZXJ0IEg=?= Windows XP Basics 0 7th May 2005 05:23 AM
how do I display "meter square" symbol in a formula cell ? =?Utf-8?B?bGF1?= Microsoft Excel Worksheet Functions 2 28th Jan 2005 09:19 PM
Went to use square and non square pixels Mike Windows XP MovieMaker 13 5th Mar 2004 06:54 PM
Shapes.. trying to print a square square keepitcool Microsoft Excel Programming 3 21st Nov 2003 05:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:13 PM.