I have a spreadsheet that I created to print out minimized in credit card
size and take with me on holiday to Poland, which displays certain values in
£STG converted to PLN Zlotych and vice versa, by virtue of multiplying or
dividing by the current exchange rate in another cell.

One column (A) of cells are formatted to accounting and to display the pound
sign (£) and the other set are formatted to accounting and zl (Polish zloty)
so the symbols all line up.

But when I set the column B formatting to the Polish currency, those in
column A then display £l (pound sign and polish l) before the amount in
Pounds Sterling.

Any ideas?