Skieer,

The quotes when there's a comma in your file are normal. If you want the
details on that, read "Text files and Excel" at www.smokeylake.com/excel.
You could use the "Space delimited *.prn) format, but I'm not sure you'll
get 80 characters if the cell contains less. Failing that, since you know
you have only one column, thus don't need the quote marks, try saving the
sheet with the Text Write Program (same site). In sheet Setup, leave the
text qualifier box empty -- it won't put quote marks around the field if
there isn't one.

Incidentally, here's my standard blurb on the term "double quotes."

A quotation mark (") is often called a "double-quote" by computer types. An
apostrophe (') is similarly called a "single quote." To the best of our
knowledge, no other species behaves in this way -- just computer types. The
problem with this highly esoteric terminology is that there are cases where
two quotation marks in a row are used (such as to represent a single
quotation mark within a text string that's wrapped in quotation marks).
Thus, "double-quote" is ambiguous. And an apostrophe just ain't a quote
mark of any kind. Note the apostrophe in "ain't," which is in quote marks.
--
Earl Kiosterud
www.smokeylake.com

"skiier" wrote in message
...
I have a spreadsheet that is comprised of a single column but thousands of
rows. The width of each cell is 80 characters. I am saveing the file as
text (MS-DOS). The problem that I encounter occurs when the cell contains
a
comma. The resulting text file inserts double quotes at the beginning and
end of the line that contained the comma. Why does this occur and how do
I
prevent this?