Currency Formatting

  • Thread starter Thread starter chalky
  • Start date Start date
C

chalky

I currently have a formula that changes the currency of a figure based
on a column heading that denotes a currency code. This formula works
perfectly but i want to be able to change the format dependent on which
currency i select. I.e when i change from € to USD not only do i want
the value to change, i want the appearence to change to $#,##0.

I dont want to do this with a macro - any ideas?
 
If you can accept the result as TEXT, then a variation of the following
should do as you wish.............

=IF(A1="US",TEXT(YourFormulaHere,"$#,##0"),YourFormulaHere)

You can add more "IF" levels as needed......

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula for currency or Macro help. 0
filter on currency number format 3
Converting amount($) of my expenditure into the base currency i wa 1
Excel macro 1
fomula which returns the amount depending on the currency code 3
Return value from column 2
Stop XL from changing format? 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top