Forum Discussion
Mar10
Apr 22, 2020Copper Contributor
multiple currencies in excel sheet
I have an excel sheet which I use to provide costing in various currencies, one column in € and the next one is in $ or £. I can switch between currencies, making currency sign (and do conversion ba...
Riny_van_Eekelen
Apr 22, 2020Platinum Contributor
Mar10 If I were you I would not worry too much about the decimal separator. I'm frequently involved in multi-currency reporting with Euros, Dollars and Pounds and just use the period for all. Haven't had any complaints. Everybody seems to understand.
Mar10
Apr 22, 2020Copper Contributor
Riny_van_Eekelenthat was my "2nd best" option but for customers in EU this does seem at least very weird...I guess in a commercial offer the difference between a thousands or decimal seprator is more relevant than in a normal report where idd everyone adapts...
thx anyway for your reaction
Martine