Simple Macro Please help

[skylinegtr]

Hello all

I desperately need some help, I have never used VB or macros before.

I need a macro that will swap xx and yy in the following type of text

xx/yy/zzzz

like a date, so with 06/25/2010, it will swap it to 25/06/2010. Then I can format it, I have thousands of cells so need a macro please!!

Please help me!

Thanks in advance!

[shg]

Welcome to the forum, skylinegtr.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[foxguy]

Hi skylinegtr;

Just letting you know that there's someone ready to help you as soon as you fix the thread title.