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

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
 
R

Roger Govier

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²
 
M

MartinW

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
 
S

Snoopy

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

Have a nice weekend
NM
 
G

Gord Dibben

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
 
S

Snoopy

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 -

Thanks to Gord and Bernard too
Regards
Snoopy
 

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

Top