Not recognising dates

Hi Guys
The date was not suitable so am reconstructing it. However when it is OK only some of the dates become dates. The remainder require me to place the cursor to the right of the date –then move to the date in the Fx position my cursor to the left and hit Enter. This move whatever it is does not show up in VBA.

Thanks in Advance
Mark

Try this...

Please Login or Register  to view this content.

It replaces all the / with a space. The dates are then a recognized date format.

Hi AlphaFrog
Did you test this and did it work for you. If so I am unlucky as I tried it no luck no Luck. In my original file i also had some Jul and Jun dates which converted themselves to dates perfectly.

Please Login or Register  to view this content.

Mark
The ' to mark as commented out is not very clear - Basically the first two lines.

I tested it on your example file. It did mess up the serial-dates that were already converted, but it converted the text-dates.

The code below will convert just the text-dates and not affect any previously converted serial-dates.

Please Login or Register  to view this content.

I didn't see any Jun or Jul dates in the example file.