reformatting dates

  • Thread starter Thread starter gerry.lisa
  • Start date Start date
G

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
 
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)
 
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
 
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)
Click to expand...
 
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........
 
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
 
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
Click to expand...

Thank you!!

....Lisa
 
Back
Top