How to convert data in General Format cells to dates
 

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.

How to convert data in General Format cells to dates
 

Hi

Mark the column.
DataText to columnsNextNextDate use dropdown to select MDYFinish

--
Regards

Roger Govier


"PE" wrote in message
...
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.

How to convert data in General Format cells to dates
 

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

How to convert data in General Format cells to dates
 

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?

"Roger Govier" wrote in message
...
Hi

Mark the column.
DataText to columnsNextNextDate use dropdown to select MDYFinish

--
Regards

Roger Govier


"PE" wrote in message
...
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.

How to convert data in General Format cells to dates
 

Yes, you should have chosen YMD, not MDY.
--
David Biddulph

"PE" wrote in message
...
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?

"Roger Govier" wrote in message
...
Hi

Mark the column.
DataText to columnsNextNextDate use dropdown to select MDYFinish

--
Regards

Roger Govier


"PE" wrote in message
...
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.

How to convert data in General Format cells to dates
 

Great, works now.

Many thanks for your help.


"David Biddulph" wrote in message
...
Yes, you should have chosen YMD, not MDY.
--
David Biddulph

"PE" wrote in message
...
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?

"Roger Govier" wrote in message
...
Hi

Mark the column.
DataText to columnsNextNextDate use dropdown to select MDYFinish

--
Regards

Roger Govier


"PE" wrote in message
...
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.