how do i stop autocorrecting the date?

[katanator]

I am trying to type 10-3 and the AutoCorrect feature keeps changing it to
3-oct. i have gone through the autocorrect tool box but i still can't figure
out how to make it stop

 

[Mike H]

Hi,

In this instance it's a pain but the usefulness of this feature outweighs
this. Autocorrect isn't causing the problem is just Excel trying to be
helpful. To get around it type an apostrophe ' before you enter 10-3

Mike

 

[Gord Dibben]

Excel will always interpret 10-3 or similar as a a date.

Preface the 10-3 with an apostrophe.

The apostrophe won't show in the cell but will tell Excel this is text.

Or pre-format the cell as Text format.


Gord Dibben MS Excel MVP