conditional number formats

  • Thread starter Thread starter I_need_help
  • Start date Start date
I

I_need_help

Does anyone know how to link the number format of a cell on the value of
another cell by using the custom number format tool and not VBA?

For example:

if cell A1 = "GBP" then value in cell B1 will be displayed as either "£
<value>" or "GBP <value>"

So if the user then enters "EUR" in cell A1, then B1 will automatically
change to either "€ <value>" or "EUR <value>".

Thanks.
 
Does anyone know how to link the number format of a cell on the value
of another cell by using the custom number format tool and not VBA?

if cell A1 = "GBP" then value in cell B1 will be displayed as
"GBP <value>"

So if the user then enters "EUR" in cell A1, then B1 will automatically
change to "EUR <value>".
Click to expand...

You can do it if you set aside an additional cell for the calculated
result.

For instance
A1 is GBP
B1 is 200
C1 is =A1 & " " & B1
then hide column B and protect column C.

If you want something else, then create a table
EUR {euro symbol}
USD $
JPY {yen symbol}

and use VLOOKUP to get the appropriate symbol.
 
Back
Top