Sightfull_M
asked on
How do I get Excel to save a CSV file with commas and not semi colons?
I am trying to import a file into my payroll program. The file is createdin excel and has to be in CSV Format. I am using MS Excel that shipped with Microsft Office 365.
Thefile refused to import, but when I open the saved file in "Notepad', I discover that the seperators between the various fileds are semi-colons are opposed to commas asit should be in a CSV file.
How do I get excel to save the file as a CSV file with comma sepeartors and not semi colons?
Thefile refused to import, but when I open the saved file in "Notepad', I discover that the seperators between the various fileds are semi-colons are opposed to commas asit should be in a CSV file.
How do I get excel to save the file as a CSV file with comma sepeartors and not semi colons?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for understanding my problem so quickly as well as the quick feedback
see the link below for more details
http://www.extendoffice.com/documents/excel/613-excel-export-to-csv-file.html