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!