How to convert data in General Format cells to dates

[PE]

I have a sheet with many cells set to General Format containing "dates" in
the form "20060913". Is it possible to select all these cells and convert
the data to show the date in the form mm/dd/yyyy?

Would appreciate your help.

 

[Roger Govier]

Hi

Mark the column.
Data>Text to columns>Next>Next>Date use dropdown to select MDY>Finish

 

[Lori]

It's a good method but needs a minor alteration: use the YMD date
format in step 3 of Text To Columns.

 

[PE]

All this does is to move the alignment from left to right, everthing else
remains the same!

I have tried both delimited and fixed width setting for the original data
with the same result.

Am I doing something wrong?

Hi

Mark the column.
Data>Text to columns>Next>Next>Date use dropdown to select MDY>Finish

 

[David Biddulph]

Yes, you should have chosen YMD, not MDY.

 

[PE]

Great, works now.

Many thanks for your help.


Yes, you should have chosen YMD, not MDY.