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

Dates
 

The IsDate function returns False if an entry is made as above, although
Excel accepts it OK.

the better to know is to try