View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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