ExcelBanter - Can I change currency format using a switch/formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I change currency format using a switch/formula (https://www.excelbanter.com/excel-discussion-misc-queries/121420-can-i-change-currency-format-using-switch-formula.html)

djdacct

Can I change currency format using a switch/formula

I have an Excel pricing model that will be used in different currencies,
Euro, Sterling, Dollar etc. Is there a way to change the currency number
format symbol for these different currencies depending on which currecny the
users prefers to see?

All times are GMT +1. The time now is 07:33 PM.