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

Discussion in 'Microsoft Excel Misc' started by Gord Dibben, Dec 7, 2006.

  1. Gord Dibben

    Gord Dibben Guest

    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
     
    Gord Dibben, Dec 7, 2006
    #1
    1. Advertisements

  2. Gord Dibben

    Guest Guest

    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

    >
    >
     
    Guest, Dec 8, 2006
    #2
    1. Advertisements

  3. Gord Dibben

    Chip Pearson Guest

    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

    >>
    >>
     
    Chip Pearson, Dec 8, 2006
    #3
  4. Gord Dibben

    Guest Guest

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

    >
    >
    >
     
    Guest, Dec 11, 2006
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Twan Kennis

    Excel cannot save to a folder containing square brackets

    Twan Kennis, Apr 13, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    1,261
    Bazza
    Apr 14, 2004
  2. Guest

    Square Character in Excel (apostrophe)

    Guest, Jun 29, 2004, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    315
    Dave Peterson
    Jun 30, 2004
  3. Guest
    Replies:
    1
    Views:
    21,655
    Guest
    Oct 25, 2005
  4. Pausert of Nikkeldepaiin

    progress meter for Calculation?

    Pausert of Nikkeldepaiin, Dec 12, 2007, in forum: Microsoft Excel Misc
    Replies:
    8
    Views:
    137
    Charles Williams
    Dec 14, 2007
  5. ttam78ouch
    Replies:
    5
    Views:
    329
    T. Valko
    Feb 13, 2008
Loading...

Share This Page