I have a spreadsheet with a mixture of pounds (£) and Danish Krona (kr).
Trouble is that the pounds now appear as £r.4,564.39 rather than £4,564.39. Krona appear as kr. 42,400.00. How do I get rid of that errant r after the pound sign? I’ve tried changing it, removing it and reapplying it but it won’t change back to a plain vanilla £.
I was just about to post this when I thought I would check another spreadsheet with pounds in it and it displayed as normal (e.g. £45). When I closed the sheet, lo and behold my mixed one was fixed. So what gives?
Eliminate spare time: start programming PowerShell
