View Single Post
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

Hi Dozzle-

What you describe is how a Tab Delimited text file works -- the quotes are
referred to as text qualifiers and are placed around cell content to
distinguish it from values (actual number values, currency, dates, etc.).
This is done so that the receiving program can interpret the data more
accurately. The 'additional' quotation marks do not show up when the data
from the file is imported by another data-based program.

Keep in mind that text data files aren't really intended for 'Human
Consumption', so if readability is your concern you may want to consider
another file format for your output.

HTH |:)

"Dozzle" wrote:

I'm trying to save an excell spreadsheet as a (tab delimited) text file.
Everytime I try to save it excel decides to add quotes to some of my cells.
How do I get it to stop doing this?
The cells it adds quotes to are cells that already have quotes in them, it
adds extra quotes around the whole cell. I really don't want that
Also cells that have numbers with commas (ie a cell with 64,4) it decides
needs quotes.
So my text file has "64,4" in it instead of 64,4 and "date "4-8-05""
instead of date "4-8-05"