Skip to main content
Ask Different

Return to Question

Edited title and content.
Source Link
edit approved Sep 28, 2019 at 14:48
nyedidikeke
edit approved Sep 28, 2019 at 14:48
nyedidikeke
  • 103
  • 6

Numbers: How to prevent Numbers from changing currency automatically?

I have a spreadsheet that has cells with two currencies.: USD &and EUR. 

I have a cell that is a USD formatted cell. I now have and the other, a EUR cell that is based on a.

The EUR cell values are results of the multiplication of the USD formatted cell values with a specificgiven figure as exchange rate. 

Now, Numbers does not let me manually change the EUR cell to EUR: WhenEUR; when I click "Cell" -> Data Format -> "Currency" and chose a EUR, it reverts back to USD.

I guess that Numbers is trying to "help" but quite frankly I would like it for me to let me chosehave control over the currency to assign a specific cell as I want. The problem is new since Versionused to prior to version 4.3 (5046). My spreadsheet worked flawlessly until now of Numbers.

As a consequence manyBecause most of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmeticbroken as I can no longer make use of more than one currency.

Thanks for your help!

Numbers: How to prevent Numbers from changing currency automatically?

I have a spreadsheet that has cells with two currencies. USD & EUR. I have a cell that is a USD formatted cell. I now have a EUR cell that is based on a multiplication of the USD formatted cell with a specific exchange rate. Now, Numbers does not let me manually change the EUR cell to EUR: When I click "Cell" -> Data Format -> "Currency" and chose a EUR, it reverts back to USD.

I guess that Numbers is trying to "help" but quite frankly I would like it for me to let me chose the currency I want. The problem is new since Version 4.3 (5046). My spreadsheet worked flawlessly until now.

As a consequence many of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmetic.

Thanks for your help!

How to prevent Numbers from changing currency automatically

I have a spreadsheet that has cells with two currencies: USD and EUR. 

I have a cell that is a USD formatted cell and the other, a EUR cell.

The EUR cell values are results of the multiplication of the USD formatted cell values with a given figure as exchange rate. 

Now, Numbers does not let me manually change the EUR cell to EUR; when I click "Cell" -> Data Format -> "Currency" and chose a EUR, it reverts back to USD.

I would like to have control over the currency to assign a specific cell as I used to prior to version 4.3 (5046) of Numbers.

Because most of my formulas are now broken as I can no longer make use of more than one currency.

added 253 characters in body
Source Link
SebastianR
SebastianR
  • 123
  • 6

I have a spreadsheet that has cells with two currencies. USD & EUR. I have a cell that is a USD formatted cell. I now have a EUR cell that is based on a multiplication of the USD formatted cell with a specific exchange rate. Now, Numbers does not let me manually change the currenciesEUR cell to EUR: When I click "Cell" -> Data Format -> "Currency" and chose a different currencyEUR, it reverts back to the currency it thinks is neededUSD.

I guess that Numbers is trying to "help" but quite frankly I would like it for me to let me chose the currency I want. The problem is new since Version 4.3 (5046). My spreadsheet worked flawlessly until now.

As a consequence many of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmetic.

Thanks for your help!

I have a spreadsheet that has cells with two currencies. Numbers does not let me manually change the currencies: When I click "Cell" -> Data Format -> "Currency" and chose a different currency, it reverts back to the currency it thinks is needed.

The problem is new since Version 4.3 (5046). My spreadsheet worked flawlessly until now.

As a consequence many of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmetic.

Thanks for your help!

I have a spreadsheet that has cells with two currencies. USD & EUR. I have a cell that is a USD formatted cell. I now have a EUR cell that is based on a multiplication of the USD formatted cell with a specific exchange rate. Now, Numbers does not let me manually change the EUR cell to EUR: When I click "Cell" -> Data Format -> "Currency" and chose a EUR, it reverts back to USD.

I guess that Numbers is trying to "help" but quite frankly I would like it for me to let me chose the currency I want. The problem is new since Version 4.3 (5046). My spreadsheet worked flawlessly until now.

As a consequence many of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmetic.

Thanks for your help!

Source Link
SebastianR
SebastianR
  • 123
  • 6

Numbers: How to prevent Numbers from changing currency automatically?

I have a spreadsheet that has cells with two currencies. Numbers does not let me manually change the currencies: When I click "Cell" -> Data Format -> "Currency" and chose a different currency, it reverts back to the currency it thinks is needed.

The problem is new since Version 4.3 (5046). My spreadsheet worked flawlessly until now.

As a consequence many of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmetic.

Thanks for your help!