Displaying different currency symbols

  • Thread starter Thread starter Eamon
  • Start date Start date
E

Eamon

Does anyone know how to return different currency symbols
in the same cell based on the input rate in another cell?
For example if I input a rate of 1.55 in A1, I want B1 to
format the cell for printing on a form with the $ symbol
and if inputting .7654 to show the ? symbol.
Thanks.
 
Hi
not really possible with formulas or custom formats. So you'll have to
use VBA (e.g. an event procedure) to achieve this
 
Thanks Frank.
Sorry to trouble you further, but would you be able to give me an idea
as to what the VBA should look like?
Thanks again.
Eamon.
 
You must log in or register to reply here.

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
DIFFERENT CURRENCY FORMATS IN FORMULA 3
Yen currency symbol 4
Currency Symbols 8
Excel Add ^ to a row of cells containing letters 3
Assistance with Formula 3
Formula for Detecting Currency Format 1
How to add new currency Symbol in Format/Cell/Currency 2

Back
Top