Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formating to show square meters ie m2
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 |
#2
|
|||
|
|||
Select your range, press Ctrl + 1, go to the Number tab,=20
press Custom and enter: General" m=B2" To enter the 2 hold down the ALT key and type "0178" (no=20 quotes) on your numeric keypad. HTH Jason Atlanta, GA -----Original Message----- I would like to be able to format in excel the square=20 meters symbol ,which is=20 m with a small 2 just above, is this possible please ? Many thanks . |
#3
|
|||
|
|||
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! ============================================== "Ska" wrote in message ... 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 |
#4
|
|||
|
|||
Great answer many thanks.
"RagDyeR" wrote: 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! ============================================== "Ska" wrote in message ... 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 |
#5
|
|||
|
|||
Excellent answer, many thanks!!
"Jason Morin" wrote: 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 -----Original Message----- 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 . |
#6
|
|||
|
|||
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 On Tue, 15 Feb 2005 05:27:04 -0800, Ska wrote: Great answer many thanks. "RagDyeR" wrote: 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! ============================================== "Ska" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
eliminate scroll bars where lists are short, show all choices | Excel Discussion (Misc queries) | |||
Show a date based on today | Excel Worksheet Functions |