Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 7th 06, 09:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 1
Default 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   Report Post  
Old December 7th 06, 11:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default 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   Report Post  
Old December 8th 06, 12:29 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 152
Default 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   Report Post  
Old December 8th 06, 01:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 7,247
Default 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   Report Post  
Old December 11th 06, 01:03 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 152
Default 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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I write multidimensional arrays in Excel Formulas? Vasil Ivanov Excel Worksheet Functions 2 September 13th 06 10:58 AM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
How do I undo write protected to excel sheet send to floppy disk ron Excel Discussion (Misc queries) 1 March 26th 06 08:55 PM
How can I write vertically in some columns on an Excel spreadshee. Teacher using spreadsheets Charts and Charting in Excel 1 January 9th 05 01:00 AM


All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017