View Single Post
  #1   Report Post  
Monalisa18
 
Posts: n/a
Default I enter date 082305 xl changes it to 5/4/25

I set the date format for the cell as: 8/23/05. When I enter date 82305, I
get 5/4/25. I've checked everything I can think of but I haven't a clue as to
what is causing this. Thanks for all help,