View Single Post
  #1   Report Post  
biglar85012
 
Posts: n/a
Default Stop numbers converting to dates.

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?