how do I display "meter square" symbol in a formula cell ?

lau · 01-28-2005, 05:06 AM

**mangesh_yadav** · 01-28-2005, 05:24 AM

enter m2. select 2, click on FORMAT > CELLS > FONT > check SUPERSCRIPT

- Mangesh

Rob van Gelder · 01-28-2005, 06:06 AM

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" <lau@discussions.microsoft.com> wrote in message
news:382BAF5D-7404-48CC-94FF-BBB22D4B6F94@microsoft.com...
>

**mangesh_yadav** · 01-28-2005, 06:35 AM

Also
Alt + 253 gives the square character.

- Mangesh

Gord Dibben · 01-28-2005, 05:06 PM

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"
<newsgroups@nojunkmail-vangelder.co.nz> wrote:

>Hold down the ALT key and type 0178 on your numeric keypad. That gives you
>the superscript two character.