View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] gerry.lisa@gmail.com is offline
external usenet poster
 
Posts: 31
Default reformatting dates

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