Macro changing date format when doing find and replace

Hi All,

My macro is changing date by mistake when doing find (.) and replace (/) in the date column
here is example date 9/02/2013. This date changes to 2/09/2013 after running the macro.

Please Login or Register  to view this content.

Can some one please help!
Thanks

Hi All,

My macro is changing date by mistake when doing find (.) and replace (/) in the date column
here is example date 9/02/2013. This date changes to 2/09/2013 after running the macro.

Try...

Please Login or Register  to view this content.

If the month and date are still reversed, check that your system's regional date format is set for day/month format.

HI Jhren It still does the same. date is set to day/month format as well.

Would you be so kind as to post a sample file...???

Thank You for your time Jhren! Please have a look at this file. It works when I do it manually but not
with the code.

Thanks.

The code I posted above works for me....

Because I'm in the USA, I opened my system's Regional settings and change my date format to d/M/yyyy, open your file, run my code and all's fine with the ouput (though there's a mismatch error for the code because of the header in A1).

As I said in Post#3, make sure your system's Regional and Language Options date format set to day/month (e.g. d/M/yyyy). This setting is not the date formatting of cells in Excel. The Regional setting is accessed though system Control Panel.