date format only showing month year

G

Guest

When I type into a cell it autmatically reverts to a month/year format
instead of month/day. for instance, if I type in "may 5" it will change the
date to May-01-2005. How can I get it to automatically select May-05-2007?
 
G

Guest

Thanks Toppers - -but when I type in 5 may it still automatically selects the
date may-1-05 ... when I was hoping it would say may-5-07 ... and I'm not
typing the quotes in here -- should have mentioned that! :)
 
G

Guest

Works OK for me (Excel 2003). If I type 5 may, it appears in the formula bar
as 05/05/2007 and in the cell as 05-may. So not sure why it is not working
for you.

(UK-based)
 

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

Top