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