It's not working. This date column (more than 8,000 dates) are in text format
as for example :

Column A Column B Column C
20080428
20080531
20080423
............
and so on

Column B to Column F are dollar and other Text. Since I want to reconcile
the spreadsheet by month I need to change Column A to date format.
If you can pl help me.

Thanks.

mzaman1952

"Dave Peterson" wrote:

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