Hi

I need help in converting date which is in dd/mm/yyyy to mm/dd/yyyy
format.

I need to write a macro that will convert column B which holds the
date to
the correct format mm/dd/yyyy & write back to same column B but in new
format.

sample data
orginal data converted data
B B(mm/dd/yyyy)
19/12/2002 12/19/2002
15/12/2001 12/15/2001

Thank you for providing any ideas.

rgds
kiwis