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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Snoopy - 26 Jan 2007 10:18 GMT

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

Reply to this Message

Roger Govier - 26 Jan 2007 10:37 GMT

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²

Signature

Regards

Roger Govier

> 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

Reply to this Message

Bernard Liengme - 26 Jan 2007 13:13 GMT

I like to use something like m2\ -> m² in AutoCorrect
Very unlikely I will need m2\ anywhere
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"

Reply to this Message

MartinW - 26 Jan 2007 10:40 GMT

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

Reply to this Message

Snoopy - 26 Jan 2007 11:16 GMT

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

Have a nice weekend
NM

> 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

Reply to this Message

Gord Dibben - 26 Jan 2007 16:44 GMT

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

>Dear Roger and Martin
>Thank you very much - this was amazing news.
[quoted text clipped - 8 lines]
>> Regards
>> Nils Morten

Reply to this Message

Snoopy - 15 Feb 2007 09:08 GMT

> Snoopy
>
[quoted text clipped - 21 lines]
>
> - Vis sitert tekst -

Thanks to Gord and Bernard too
Regards
Snoopy

Reply to this Message