Type 9 Apr or 9 April and format cell (Custom) as mmm-dd-yy

"Alex" wrote:

> Hi, when I try to type in a date, it keeps coming up a totally different
> date, for example, when I try to type in a date, it only comes up with the
> first of every month, and the year 2002. What I want it to do is, when I
> type in "april 9" it will automatically populate" apr-9-06"