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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To make pdf to work as word 1
Messages showing in "Find related" but not in Conversation view 0
Julian Date Conversion 1
Returning a Date with Multiple Criteria Lookup Values 0
Creating Forms 0
SUM Q 2
Problem formatting dates from CSV file 2
If Function 1

Top