View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyndi cyndi is offline
external usenet poster
 
Posts: 30
Default Covert Data the comes for a CVS

I have a file that is sent to me in a .CVS the date numbers so up as
20070220, I need it to be 20-Feb-07, everytime I try to do this I get the
"railroad tracks" ########(yes my column is strecthed out). I tried every
date format, custom formats, any help would be great. Thanks