OK Im one step away from completing my spreadsheet and I have this problem which has been ongoing throughout development.
The dates that I am pasting into my spreadsheet are formatted as dd.mm.yyyy , the macro that I run to check that the dates are correct will only work if the date is in dd/mm/yyyy format. So I do a simple Find and Replace ie "." for "/".
The problem is after the Find and Replace some not all of the dates are rearranged as: mm/dd/yyyy. This of course throws out my data validation.
Note, I've tried Format cells>Date but the macro still doesnt work and only recongnises "/". (Ive included the macro below in case theres a workaround there instead).
Bookmarks