Changing Date Format from 2005-08-03 to 03/08/2005

I am trying to figure out how to change the date format for a large amount of fields. I need to change them from this

2005-08-03
2006-12-06
2004-12-08

to this

03/08/2005
06/12/2006
08/12/2004

I used this function to reverse the numbers =RIGHT(C7,4)&LEFT(C7,5) and get this 08-03 2005 and cant figure out how to get rid of the dash and the format it to read like 03/08/2005.

Any help would be appreciated!

i think simply by changing the format in the cell/column should work and if the column is in a text format try doing this:
select the column and press Alt+D+E+F

if this doesn't work then try this in the next column assuming the date is in cell b3 and you will put this formula in cells c3

=DATE(LEFT(B3,4),MID(B3,6,2),RIGHT(B3,2))

Thanks for the quick response. I just tried the bottom formula and it give me another date. This is the date in the field: 2004-04-15 and it gives me this 12/15/2099

can you tell me what is the length of the cell you have 2004-04-15 stored into? (in case you need, you can check the length of the cell, by using a "len" function)

the length of the field is 11

no issues try this formula:

=DATE(MID(B3,2,4),MID(B3,7,2),RIGHT(B3,2))