Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George
 
Posts: n/a
Default Date Format

On my spreadsheet I have the cells setup for Date formatting, Mar-98, when I
enter anything other then a month and year in 2006 and then double click on
the cell it changes the year to 2006

Example - If I enter Mar-08 in the cell and then double click on the cell it
changes the value to Mar-06

What gives - Thanks