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
Bookmarks