Changing Date Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
click on format at top. click on cell. from list click on date. to the right you can pick your choice
 
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!
 
Back
Top