View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vpuckett
 
Posts: n/a
Default How do I change the date format when importing a txt file?

My import data imports as yyyy/mm/dd even when I tell it to import m/d/y.
When I try to format the column using format cells, custom, mm/dd/yyyy, I get
###########. I tried to change width of column as was suggested in help, but
that does not work. I know I have done this before, but it escapes me now.