You can try the below to convert the entire column at a stretch.

Select the column.
From Data menu select 'Text-to-Columns' option...
Hit Next...Next will take you to Step 3 of the Wizard
Select Column data format as 'Date'
Select the format in which your data is (YMD)
Hit Finish.

Excel now converts all the text dates to the date format.

If this post helps click Yes
---------------
Jacob Skaria


"Vic" wrote:

I have 20061030 in a cell that is formatted as general. How do I change this
into date format like 10/30/2006? If I format cell and select date then it
gives me #############.