Formating to show square meters ie m2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to format in excel the square meters symbol ,which is
m with a small 2 just above, is this possible please ?

Many thanks
 
Select your range, press Ctrl + 1, go to the Number tab,
press Custom and enter:

General" m²"

To enter the 2 hold down the ALT key and type "0178" (no
quotes) on your numeric keypad.

HTH
Jason
Atlanta, GA
 
You could enter m2 in a cell, and then select the "2" in the formula bar,
Right click in the selection and choose "Format Cells".
Then click in "SuperScript", then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I would like to be able to format in excel the square meters symbol ,which
is
m with a small 2 just above, is this possible please ?

Many thanks
 
Excellent answer, many thanks!!

Jason Morin said:
Select your range, press Ctrl + 1, go to the Number tab,
press Custom and enter:

General" m²"

To enter the 2 hold down the ALT key and type "0178" (no
quotes) on your numeric keypad.

HTH
Jason
Atlanta, GA
Click to expand...
 
To save all that typing try this macro.

Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
'0179 for cubic meters
End Sub


Gord Dibben Excel MVP
 
Back
Top