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)



" wrote:

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