View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clark Clark is offline
external usenet poster
 
Posts: 49
Default Date is displaying 00-Jan-00 when I type in 11/16/09.

When I type in a date field in my excel file the date "11/16/09" it is
displaying 00-Jan-00 instead of 16-Nov-09. Why is this happening??

Thanks!