Converting European format CSV to American

R

Rich

The European CSV uses semi-colons and has commas in
numbers to denote decimal. I Need to be able to import to
Excel with numbers in decimal (.) format. Is there an
Excel setting? I can save the csv as txt and open and
choose the semi-colon delimiter - but that is clunky and
doesn't cover the decimal problem without setting an
option during the import to denote amounts use comma
rather than period.
 
F

Frank Kabel

Hi
one way (also clunky...):
- set the regional settings according to the format of your CSV-file
- import the file and save it
- change the regional settings back to the original values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Files saved as csv files are actually saved as text files? 2
Convert European Date format to American Format 3
European CSV File format 2
European vs American decimals 1
.csv Re-Format Question 1
Change date format to European format 3

Top