I would think Text to columns.

Ensure you have 2 columns available to the right of your date column.

Click Data - Text to Clumns...

Select Fixed Width and click between the 4th and 5th charatcers, then
between the 6th and 7th characters. Should break it out nicely. If you want
to combine back, you can enter a forumla to the right = month cell &"/"& day
cell &"/"& year cell.

"James" wrote:

I have raw data that I export from a site for work and the date comes over as
Internationa ISO however it has no dashes in it to help format. Example it
looks like this... 20080302 just straight numbers. i need to convert this to
US date format.

Any ideas?