how do I display "meter square" symbol in a formula cell ?
|
Hold down the ALT key and type 0178 on your numeric keypad. That gives you
the superscript two character. -- Rob van Gelder - http://www.vangelder.co.nz/excel "lau" wrote in message ... |
And if you want it as a Custom format.......
In Custom dialog box enter 0"m2" To enter the 2 above as superscript, enter the m then ALT + 0178 Macro on a button or shortcut key combo......... Sub sq_Meters() Selection.NumberFormat = "0"" m" & Chr(178) & """" End Sub Note cubic meters is ALT + 0179 Gord Dibben Excel MVP On Fri, 28 Jan 2005 22:24:22 +1300, "Rob van Gelder" wrote: Hold down the ALT key and type 0178 on your numeric keypad. That gives you the superscript two character. |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com