Date conversion

M

Mike H

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
 
A

art

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.
 
C

Charlie7805

This works perfectly. Thanks!!!

art said:
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.
Click to expand...
 
G

Gord Dibben

Data>Text to Columns>Next>Next>Column Data Format>Date>YMD and Finish.


Gord Dibben MS Excel MVP
 
Top