reformatting dates

[gerry.lisa]

10/3/2007
Thu Oct 4, 2007
Sat Oct 6, 2007
Tue Oct 9, 2007
Thu Oct 11, 2007
Sat Oct 13, 2007
Mon Oct 15, 2007


I have a series of dates....when I try to reformat them all to m/d/
yyyy only some of them are changing from the current expanded day
month date, year

The first one here changed but the others didn't.

Any suggestions?? I'm thinking I might have to convert them all to
something and then format to what I want.

....Lisa

 

[Guest]

I'm guessing that you have text instead of numbers ni those cells. in an
adjacent column, put this formula and come back and let us know what you see.

=ISNUMBER(A1)

 

[Gord Dibben]

I would assume the dates that don't change are text.

Try this..............

Data>Text to Columns>Fixed width>Next

Double-click on the separation line you don't want leaving just the line between
the day and the date.

Next>Select Skip the column with days and Finish.


Gord Dibben MS Excel MVP

 

[gerry.lisa]

Most cells came back FALSE

....Lisa

I'm guessing that you have text instead of numbers ni those cells. in an
adjacent column, put this formula and come back and let us know what you see.

=ISNUMBER(A1)

 

[gerry.lisa]

I did this except I didn't see" Select Skip the column with days"

It didn't seem to change anything

....Lisa

Not sure what I did wrong........

 

[Gord Dibben]

Data>Text to Columns>Fixed Width>Next. Double-click on the second break line to
eliminate the second break line>Next

With the days column selected>Column Data Format>Do not Import Column(Skip)


Gord

 

[gerry.lisa]

Data>Text to Columns>Fixed Width>Next. Double-click on the second break line to
eliminate the second break line>Next

With the days column selected>Column Data Format>Do not Import Column(Skip)

Gord

Thank you!!

....Lisa