I have a large table of values denominated in Euros. For some reason, Germans switch commas and decimal points (eg 700.000,00).
As a result, my American excel program on my American machine does not recognize the numbers properly. And as far as I know, I can only Find/Replace either the comma or the period, and do the other manually, because once I fix one, then for example, I'll have periods for both commas AAND decimal points. All of this also confuses the Format Cells: Number tab, making it impossible to address the issue there.
Is there a way to change the symbols without reconfiguring the settings on my entire system each time I want to do this?
Thanks in advance...
Bookmarks