Remember Me?

#1
December 7th 06, 10:49 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Dec 2006 Posts: 1
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

#2
December 8th 06, 12:22 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22,909
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

#3
December 8th 06, 01:29 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 152
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

#4
December 8th 06, 02:28 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 7,247
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" <[email protected] 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

#5
December 11th 06, 02:03 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 152
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" <[email protected] 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Vasil Ivanov Excel Worksheet Functions 2 September 13th 06 10:58 AM Excel Worksheet Functions 0 August 8th 06 06:04 PM ron Excel Discussion (Misc queries) 1 March 26th 06 08:55 PM Teacher using spreadsheets Charts and Charting in Excel 1 January 9th 05 02:00 AM

All times are GMT +1. The time now is 10:01 PM.