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

  • Thread starter Thread starter Gord Dibben
  • Start date Start date
G

Gord Dibben

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
 
² = ALT(253) on my keyboard ▓ = ALT(178). Really getting confused by ALT
character lookups! Can someone shed some light?
Lou
 
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)
 
Thanks Dave. Good day anytime I learn something new. That is what I get for
referancing an old DOS Manual.
Lou
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re: cannot right-click a shortcut menu in Excel 0
Re: cannot right-click a shortcut menu in Excel 1
Re: how do I quickly insert numbers 1 to 100 in a column in Excel? 0
How do I write a macro to increase the value of any cell by 1? 2
How do I re-arrange numbers in a column? 7
How do I type a # (01020) in Excel & have the 1st 0 stay? 5
How do I tell EXCEL to use macros in ThisWorkBook. 3
if I know the password, how do I remove it from a large no of ppts? 2

Back
Top