Exporting From US Excel and Importing in Euro Excel

T

Tim Rogers

I'm curious how this situation is handled.

You have a worksheet that has some columns that represent U.S. monetary
values that include decimals (e.g. 19.28). You export that to a .csv file
(comma delimited file). You then have someone in Europe who wants to import
this file, but they use commas as the separator in their monetary values.
Is there a way they can import this, but also convert the decimals in the
monetary values to commas?

Thanks,

Tim
 
D

DavidP

Not sure if it would work Tim but could you use Find/Replace on the
range of "Values" changing "." to ","

David
 

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

Moving Text from Word to Excel (and having it set into 2 columns) 4
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Decimal dot to Decimal Comma 3
Can an Excel spreadsheet be exported to a comma-delimited import . 1
Export data from SQL into Excel files 2
Importing Excel file into Outlook 1
How to use Windows command within Excel macros 2
CSV file into the Excel 3

Top