I have a whole spreadsheet where when I type in the date i.e. 3/5/05 it then
shows 1/00/00 as the date! I have tried changing the format to the many
different ways to show the date, but I can't get it to show 3/5/05! Is there
something I am missing?

Thank you so much for your help!

Katie