Go to Format CellsNumberNumber and uncheck the "Use 1000 Separator box".
The save as CSV.

--
Ian
--
wrote in message
ups.com...
I am using the following Excel function in exporting a Excel worksheet
into a CSV file:

Sheets(1).SaveAs "c:\abc.csv", 6

The worksheet is exported successfully as a CSV file but the text
columns in the spreadsheet are correctly exported as :

Blue Film Package but the columns which are numeric are exported in the
following format:

"52,177", "1,914,446","2,166,925"

I do not want the comma 1000 seperators and the quotes in the csv file.
Appreciate if you could share the code to accomplish the export into a
; or tab or anyother character delimitation.

Thanks
Karen