Numbers

Hello

can anyone help me to turn off auto currency formatting in Numbers 4.3? I am trying to write spreadsheets with exchange rates and therefore multiple currencies but the auto-formatting is overwriting the destination cell.

Thanks