replace Coma's with Decimal points

[Bennyton]

Hi all, I work for a US Company, but am working for them in Ireland, which would normally be totally fine, as we both use the same format for currencies, ie €1,000.00 however, in their infinite wisdom, they have set SAP to export spreadsheets and display currencies in the European(mainland Europe) format, which would be €1.000,00, the main problem arises when i try to copy the spreadsheet data and paste into an existing excel file that requires that data to perform various calculstions on it, but it won't multiply 1.55 by 1,55 etc.. does anyone know a quick way of formatting them to remove the , and replace it with a .?

Thanks again, this forum is a life saver!

 

[Andrew Poulsom]

Try Edit|Replace dot with nothing then Edit|Replace comma with dot.

 

[Bennyton]

Thanks a million Andrew, works like a gem!