Date Entry Issue
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
|