Assuming cell is formatted as mmm-dd-yyyy type '5 may' (no quotes).

"nikkiabm" wrote:

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?