View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JadedMan JadedMan is offline
external usenet poster
 
Posts: 1
Default Stop 10-6 from changeing to 6-Oct, or anything else.

Trying to keep track of sports scores, and everytime I enter anything that
could be a date it auto-formats. I don't want it to change it at all, is
there a way to turn off formating? Or at least for times that I have this
issue?

When I got into Format Cells, all of the options still change the number to
something crazy like 39361, or worse.

Any help with this would be greatly appreciated, thanks!