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

[bmwx21]

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!

[Roshan10043]

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

Please Login or Register  to view this content.

[bmwx21]

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

[Roshan10043]

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)

[bmwx21]

the length of the field is 11

[bmwx21]

I just realized that there is a space in the front of all the dates so that's why it is 11? Not sure why.

[Roshan10043]

no issues try this formula:

Please Login or Register  to view this content.

[bmwx21]

Ahh Roshan10043 you rock! That did it. Thanks soooo much