Sorry about that. I tested by entering 9/06 and it returned "9/2006". It,
as you know, didn't work when typing "9/01".

What is the format in which the user is suppose to enter the date? Or what
are all the different formats in which someone could or is allowed to enter
the day. Once that is known, then appropriate steps may be taken to ensure
the final result is as you wish.



"Barb Reinhardt" wrote in message
...
That doesn't solve the problem if the user enters the date as 9/01. It
assumes that what's entered is the month and DAY, not the year. I need
to
ensure that they enter the year and am not sure how to address this, hence
my
post.

"PCLIVE" wrote:

If you want the format of "9/2001", I would think you could just format
the
cell as:

m/yyyy


"Barb Reinhardt" wrote in
message
...
I'm sure this isn't the first time this problem has cropped up so I'm
asking
for assistance.

I have a worksheet that requires the user to enter dates into several
cells
in the workbook. The dates are displayed as MMM-YY. If the user
enters
9/01, they get 9/1/2006 instead of 9/2001. Is there any way to ensure
that
they enter the dates correctly. I'd like to add it to the worksheet
change
event if necessary.

Thanks