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

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

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

1. Type the text you want to superscript, such as "m2".
2. Highlight the number or letter you want to superscript.
3. Right-click on the highlighted text and select "Font" from the drop-down menu.
4. In the Font dialog box, check the box next to "Superscript" under the Effects section.
5. Click "OK" to close the Font dialog box.
   
   Alternatively, you can use the keyboard shortcut "Ctrl + Shift + +" to apply the superscript formatting to the selected text.
   
   Once you have applied the superscript formatting, the selected text will appear smaller and raised above the baseline, indicating that it is a superscript. This is a great way to format units of measurement, chemical formulas, and other scientific or technical notation in your Excel spreadsheets.

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

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

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
...
² = 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

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
...
² = 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