| I just tried this and while what you say is true, I found a workaround for the issue. Euros are now treated like numeric values and you get the euro character (€). (1) Select some _empty_ cells you wish to make euro currency (2) Right click -> Format Cells (3) Category should be "Currency" (4) Format should be "EUR € English (Ireland)" (5) Save and then enter numbers into the cells (the euro symbol should be appended) It seems to work with things like sum() and you still get the euro symbol and them being the correct "currency" cell type. Here's the "Format Code" which you can just paste into the Format Code box to save yourself time with the above procedure: [$€-1809]#,##0.00;[RED]-[$€-1809]#,##0.00
No white space around it.Pasting remains completely broken. They need to fix that. |