View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cindyt cindyt is offline
external usenet poster
 
Posts: 17
Default Date formatting error

I have a spread sheet that has a column for dates - formatted for dates-

In some cells, when I enter 8/1/09 it turns it into a formula and gives me
1/0/1900. I've tried deleting, erasing, everything! Please help.

thanks! ckt