View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Importing data with Text Wizard

When I import a specific formatted data file into Excel 2003 the text wizard
looks at the data and announces that "The Text Wizard has determined that
your data is Fixed Width." However, that is incorrect. It is .csv data.
Here is a typical data record:

"2-5-2008 7:59","2-5-2008 9:20","123456.US - 0000.1","Continue addressing
inventor commments, and modify figures and specification to overcome
potential reference. "

Is there any way to re-educate the Text Wizard - or to force it to always
assume that data are .csv?

Thanks.


Jim (a.k.a. ORTNPALMS)