Exporting From US Excel and Importing in Euro Excel

  • Thread starter Thread starter Tim Rogers
  • Start date Start date
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
 
Not sure if it would work Tim but could you use Find/Replace on the
range of "Values" changing "." to ","

David
 
Back
Top