How does one disable Auto-Formatting of dates?

[Clarissimus]

Whenever I type something like 2-3 it automatically gets changed to a date
(i.e. 3 Feb.) I've tried changed the cell properties to "general" but that
only covert the date to the Excel day number (c. 38 000). When I delete it
and start over the autoformat is on again.

How do I stop this? I just want the computer to display two numbers with a
dash in between. Is that too much to ask?

[Dave Peterson]

Pre-format the cell as text or start your entry with an apostrophe: '2-3



Clarissimus wrote:
>
> Whenever I type something like 2-3 it automatically gets changed to a date
> (i.e. 3 Feb.) I've tried changed the cell properties to "general" but that
> only covert the date to the Excel day number (c. 38 000). When I delete it
> and start over the autoformat is on again.
>
> How do I stop this? I just want the computer to display two numbers with a
> dash in between. Is that too much to ask?

--

Dave Peterson