View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lizzie
 
Posts: n/a
Default Weird dates appear in cells when I use Date format! Why?

when I change the formatting of a group of cells to a Date format and hit the
Enter key, some unknown random date appears in all the cells. Even when I go
into the cell and change the date, it doesn't change it to the correct date.
Why might this be happening?