Dates

[Don Lloyd]

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

 

[abcd]

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

the better to know is to try