Thread: My date is coming up 0-Jan-00 when I type current date. Why?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default My date is coming up 0-Jan-00 when I type current date. Why?
You have a Lotus 123 setting toggled on.

Tools|Options|transition tab (in xl2003 menus)
Uncheck all those options.

Re-enter your date.

ps. Please include your question in the body of the message--not just the
subject.

Clark wrote:

--

Dave Peterson
Reply With QuoteReply With Quote