Changing Date Format

[Guest]

As of right now, I have a column of dates that read year first, then month, then day. For example, 20031014 meaning October 14, 2003. How can I format these cells so that they will read 10/14/2003? Is this even possible?

Thank you for any help

 

[Frank Kabel]

Hi
you need VBA for this. See
http://www.cpearson.com/excel/DateTimeEntry.htm
for such a macro

 

[Gord Dibben]

Annie

In an adjacent column.........

=DATE(VALUE(LEFT(A1,4)), VALUE(MID(A1,5,2)), VALUE(RIGHT(A1,2)))

Format as mm/dd/yyyy

Gord Dibben Excel MVP

 

[Guest]

click on format at top. click on cell. from list click on date. to the right you can pick your choice

 

[RagDyer]

Select the cells with the numbers, then:
<Data> <TextToColumns>,
Click <Next> <Next>,
Then click "Date" and choose "YMD",
Then <Finish>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

As of right now, I have a column of dates that read year first, then month,
then day. For example, 20031014 meaning October 14, 2003. How can I format
these cells so that they will read 10/14/2003? Is this even possible?

Thank you for any help!