I get the follow output from my datbase which is a date field.

7012005
12012005

I am trying to format it in 07/01/2005 fashion.
If I try to format it to a date stylein excel the dates do not convert
correctly. Any thoughts on how to get this format correctly.