View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dodgers32 dodgers32 is offline
external usenet poster
 
Posts: 3
Default I can't convert from mm/dd/yy to month dd, yyyy

I have a list of dates just over 1000 lines long. Dates range from
01/01/1993 to 12/31/2003. When I attempt to convert the column from
01/01/1993 to January 1, 1993 only some of them (about 30) will convert. The
rest don't change at all. I've tried going to other formats and the same
data changes each time. Help...