If you have a single column of these "dates", you can select that column.
Data|Text to columns
fixed width (but remove any lines excel guesses)
choose Date (YMD)
and finish the wizard

Then format the cells the way you like.

mzaman1952 wrote:

In my spreadsheet I have date like "20080428" which I want to convert to
04/28/08 or any regular date. Can I able to do it?

--

Dave Peterson