View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default saving an excel file as text without text in quotes

Start with a completely blank worksheet.
Put hello world in cell A1
Save the file as .csv
Open the resulting file with Notepad

You should see no quotes
--

Gary's Student


"John" wrote:

I am creating a comma delimited (text) file for upload to another
application. The file is a tab in Excel (2000). No matter what (.txt) file
format I select to save as, each line of the output file is in quotes (which
are not present in the excel source file. As a result, the upload
application doe not recognize the data.