How do I export data from Excel as a series of comma-separated val

[gbergren]

I am using Excel 2000. I entered my data in a spreadsheet, and saved it as a
CSV file. Now I need to change it to comma-separated values and send it in
an e-mail. Here's an example of what I am doing. Swamp
Thing 1972 1 FN 1 None None 24.5
Now I need that to be separated by commas instead of cells. Also, it took
out my dollar signs and zeros, and I want them back. What do I do?

 

[Tom]

I use Excel 2003
File|Save As , select file type as CSV file.
Then open *.csv with text editor not Excel.
You example data will look as below:

Swamp Thing, 1972, 1, FN, 1, None , None ,
24.5

Tom
www.knowlesys.com
Web Data Extraction Expert

 

[gbergren]

Thank you Tom, that worked great!