xl2003 does the same thing--and I didn't test, but I don't think that this
behavior has changed from earlier versions.
You could use a macro and write code and have complete control over what you
write.
Here are three sites that you could steal some code from:
Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly:
http://www.smokeylake.com/excel/text_write_program.htm)
Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm
J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html
Earl's program may work right out of the box.
ExcelStudent wrote:
Excel 2007 has this nasty feature that brackets text strings with a pair of
double quotes when outputting them to a tab-delimited (.txt) file, if the
text string contains a comma.
This is apparently new with the 2007 edition.
Anyone know how to disable this "feature"?
Tom
--
Dave Peterson