Formating to show square meters ie m2

S

Ska

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
 
J

Jason Morin

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
 
R

RagDyeR

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
 
S

Ska

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...
 
G

Gord Dibben

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
 
Top