R.
It's a windows thing (couldn't tell you in others but...) in 98
Start -> Control Panel -> Regional Settings
Under the number tab you'll see
List Separator, change it to a "," instead of ";"
change will affect ALL programs!
If that doesn't suit you, a macro might help
Sub ExportCSV()
Dim fs, f
OutFile = Application.GetSaveAsFilename(FileFilter:="CSV (Comma delimited)(*.csv), *.csv")
If OutFile = False Then Exit Sub
ActiveSheet.UsedRange.Select
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile(OutFile, 2, -2)
For Rcount = 1 To Selection.Rows.Count
For CCount = 1 To Selection.Columns.Count
Outline = CStr(Selection.Cells(Rcount, CCount).Text)
f.Write Outline
If CCount <> Selection.Columns.Count Then f.Write ", "
Next
f.Write vbCrLf
Next
f.Close
Set f = Nothing
Set fs = Nothing
End Sub
David McRitchie has a good site if you are unfamiliar with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Dan E
