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

  • Thread starter Thread starter Guest
  • Start date Start date
Hold down the ALT key and type 0178 on your numeric keypad. That gives you
the superscript two character.
 
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
 
You must log in or register to reply here.

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

Sum formula when cell cantains alphabets too 0
How to combine a symbol and a formula 2
Insert newline in cell through formula (excel 2003) 2
Can I format one cell so that it affects another cell? 4
convert meters to feet/inches 17
Excel Count If Formula Question 1
Smart Meters anyone? 9
Creating a formula for Hydraulics 3

Back
Top