You can use Data-Text to Columns to automatically convert a whole column.

Select Data-Text to Columns
Select Delimited, and then next
Deselect all delimiters (this way it won't split up your cells)
Select Date and choose YMD (for year, month, day) and click finish.
This will convert any series of numbers (like 20060330) in that column to a
date. You can then change the date format to a normal date format. A custom
format of
dd/mm/yyy
will show the dates how you want them.

"Vass" wrote:

I have imported a csv file and the date is in US format like this
20060330 without slashes or stops separating yyyy/mm/dd

Any idea how I get this now to read UK format dd/mm/yyyy with slashes ?

thanks

--
Vass