View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nikkiabm nikkiabm is offline
external usenet poster
 
Posts: 2
Default date format only showing month year

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?