You need to use text format either by formatting ahead of entry or precede
it with an apostrophe
then you can use a formula that will extract the necessary numbers and use
that help column of formulas to sort by (can be hidden) There is no way to
turn off Excel date conversion and the other option would be text since the
string 02-08 is a text string

--
Regards,

Peo Sjoblom


"biglar85012" wrote in message
...
How do I stop a number from being converted to a date? Example: When I
enter the number 02-08 it automatically converts to "Feb-8". I have tried
formating the cell as a number, but the date conversion overrides the
formating and makes it a date. I have tried entering the number as text,
but
then have trouble sorting.

I realize that enter a digits from 1 thru 12 with a hyphen causes the date
conversion. How do I TURN IT OFF?