please disregard, I resolved this from a previous post.
--
TIA

Pete


"Pete" wrote:

I have an imported csv format table & saved it as an Excel 2003 spreadsheet.
On import, the date lists for example:

20061011

I would like to convert this 11th Oct 06 date to a format that Excel
recognizes as a date.

Can anyone advise me how I can do this?

Many thanks

Pete