Date conversion
 

How can I convert dates from 20020113 to 1/13/02?

Date conversion
 

Hi,

If 20020113 is a properly formatted date then simply change the cell format to

m/dd/yyyy

If it isn't a correctly formatted date then post back.

Mike

"Charlie7805" wrote:

How can I convert dates from 20020113 to 1/13/02?

Date conversion
 

If the 20020113 is in cell A1, then enter in B1 =LEFT(A1,4) and in cell C1
=MID(A1,5,2) and in cell D1 =MID(A1,7,2) and then in cell E1 =DATE(B1,C1,D1).
let me know if that helps.

"Charlie7805" wrote:

How can I convert dates from 20020113 to 1/13/02?

Date conversion
 

This works perfectly. Thanks!!!

"art" wrote:

If the 20020113 is in cell A1, then enter in B1 =LEFT(A1,4) and in cell C1
=MID(A1,5,2) and in cell D1 =MID(A1,7,2) and then in cell E1 =DATE(B1,C1,D1).
let me know if that helps.

"Charlie7805" wrote:

How can I convert dates from 20020113 to 1/13/02?

Date conversion
 

DataText to ColumnsNextNextColumn Data FormatDateYMD and Finish.


Gord Dibben MS Excel MVP

On Tue, 4 Mar 2008 10:07:03 -0800, Charlie7805
wrote:

How can I convert dates from 20020113 to 1/13/02?