How to change default date format of dd-mmm?

  • Thread starter Thread starter Ken B.
  • Start date Start date
K

Ken B.

When I enter a date in m/dd format, e.g. "7/15",it is
automatically converted to dd-mmm format ("15-Jul").
How can I change this so it stays in 7/15 format?
Thanks.
 
Ken

Format the cell as m/dd from Format>Cells and click on Date and m/dd

Andy.
 
Ken

I don't know of a way to make it always show 7/15. If you just need to
display 7/15, and it doesn't need to be a date you can precede the entry
with a '

Andy.
 
You must log in or register to reply here.

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

Similar Threads

Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Date Format 3
counting records by month and year / date format issues 1
date format - excluding year 2
Date format in VBA 4
TextBox will not clear date??????????? 4
Extract the Month from a cell with a formatted date 3
Returning the month (mmm) from cell in date format dd/mm/yyyy 1

Back
Top