Thread: Date changes to 0-Jan-00 when I leave cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hvannest hvannest is offline
external usenet poster
  
Posts: 3
Default Date changes to 0-Jan-00 when I leave cell
The cell format is set to Number, Date, 14-Mar-01. I enter the date, and
when I press Enter, the date converts to 0-Jan-00. Any thoughts? Thank you.
Reply With QuoteReply With Quote