Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top