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
|