I am currently working on a database with 500+ incorrectly entered
birthdays. The birthdays are entered DD\MM\YYYY and I need it to be
MM/DD/YYYY. Since the Months and Days are switched, if I just switch
the \ to / it doesn't format correctly. How can I create a macro that
will change the birthday to how I need it and then go onto the next
cell below.

Thanks

select the column and do Data=Text to columns, select fixed width, then in
the last dialog of the wizard specify the column as date with the current
Order of month day and year

--
Regards,
Tom Ogilvy



" wrote:

I am currently working on a database with 500+ incorrectly entered
birthdays. The birthdays are entered DD\MM\YYYY and I need it to be
MM/DD/YYYY. Since the Months and Days are switched, if I just switch
the \ to / it doesn't format correctly. How can I create a macro that
will change the birthday to how I need it and then go onto the next
cell below.

Thanks