Creating Macro to edit cell

[Tiffany.Pettit@gmail.com]

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

[Tom Ogilvy]

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



"Tiffany.Pettit@gmail.com" 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
>
>