Autocorrect in Excel - "m2" (square meter notification)

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey guys
Do anyone know how to make the autocorrect-function expresse "m2"
(square meter) to a format where "2" is shown as superscript?

Regards
Nils Morten
 
Hi Nils

You can do this through Tools>Options>Spelling>autocorrect options
Change m2
With m then Alt+0178
that is type m then hold down the Alt button as you type 0178 (from the
Numeric Keypad only).
Nothing will appear after the m until you finish typing 0178 and release
the Alt key when you should see m²

HOWEVER
I would not recommend this. You would not be able to type M2 as a cell
reference.
Instead, why not choose a key from your keyboard that you never normally
use like the ¬ key which is Shift + the top left key on my UK keyboard.
Use this as the With key in the change above, then use that whenever you
want to type m²
 
Hi Nils,

Set replace m2
with m alt+0178

alt+0178 is a unicode character
to input unicode hold the alt button then type 0178 on the
number pad (not the numbers at the top of your keyboard)
then release alt.

HTH
Martin
 
Dear Roger and Martin
Thank you very much - this was amazing news.

Have a nice weekend
NM
 
Snoopy

Another method is a small macro to add m² to any selected cells.

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


Gord Dibben MS Excel MVP
 
Snoopy

Another method is a small macro to add m² to any selected cells.

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

Gord Dibben MS Excel MVP





- Vis sitert tekst -
Click to expand...

Thanks to Gord and Bernard too
Regards
Snoopy
 
Back
Top