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

Your format is for mmm-yy (month-yr). Excel interprets your input as March
8, 2006 and is displaying it per your format.

If you want Month-day, use

mmm-dd

as the format

"George" wrote:

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