Dates
Hi,
Excel97
I'm having a problem with dates as follows.
A column of cells is formatted as "dd mmm yy".
Using the Worksheet Change Event I want to ensure that an entry is in a
valid date format.
I would like dates to entered as "dd/mm/yy"
The IsDate function returns False if an entry is made as above, although
Excel accepts it OK.
Don
|