View Single Post
  #2   Report Post  
Posted to microsoft.public.mac.office.excel,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Disable auto-formatting dates.... GRRR!

If the file is a .txt file then when you do File | Open Excel will
automatically take you through the Text Import Wizard. Here you can
specify the delimiters, what line to start at etc, but you can also
tell Excel (on the 3rd panel) that you want some columns to be treated
as text. So, maybe if you renamed the file to .txt ...

Hope this helps.

Pete