View Single Post
  #1   Report Post  
Carter
 
Posts: n/a
Default Excel writes "May 10" when I input "5-10". How to stop this?

I write a number range - e.g. 5-10 (as in "five to ten"), and Excel
automatically turns it into a date (e.g. May 5th). How do I stop this
irritating function? (If I wanted to write a date I'm not so stupid I
couldn't just write it.)