conditional number formats

[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.

 

[Peo Sjoblom]

You would need VBA for that.

 

[Jonathan Rynd]

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>".

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.