Thread: Date is displaying 00-Jan-00 when I type in 11/16/09.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Date is displaying 00-Jan-00 when I type in 11/16/09.
In xl2003 menus:
Tools|Options|Transition tab
Uncheck all those lotus 123 settings.

Clark wrote:

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!

--

Dave Peterson
Reply With QuoteReply With Quote