Thread: displaying yy instead of yyyy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
josh7 josh7 is offline
external usenet poster
  
Posts: 7
Default displaying yy instead of yyyy
When I enter a date value in excel spreadsheet like 01-Jun-2005 ,its saving
the value as 01-Jun-05 instead of 01-Jun-2005.What should I do to save it as
01-Jun-2005.
Thanks,
Joshua

Reply With QuoteReply With Quote