Thread: Date format in Excel 2007 mm/dd/yy not appearing correctly
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RickGCR RickGCR is offline
external usenet poster
  
Posts: 1
Default Date format in Excel 2007 mm/dd/yy not appearing correctly
Cannot find a way to format date in a cell. I've selected Custom and
mm/dd/yy. In office 2003 Excel I could type in Jan5 and it would appear as
01/05/09, the 2007 version will not convert, Jan5 comes up as 01/01/05. I've
tried to change numerous times in every option I can find and nothing works.
Is this a VIsta problem?
Reply With QuoteReply With Quote