Dynamic currency formatting

Hi,

I've looked around for this one but I can't quite find what I'm looking for. Most solutions are about currency exchange rates etc

What I'm after is a dynamic currency formatting based on the value of a cell.

For example.

If cell A1="£" then all my cells with currency would display £ in front of it.

Each workbook will only ever deal in one currency, but clients are from all over the world. No currency exchange is needed, it's literally just a formatting issue.

If B1 was the value I wanted in dynamic currency, the only solution for each cell would be =A1&" "&B2

But this is messy.

As always, thanks for any help

Perfect!!!!!!

Thank you!