Results 1 to 3 of 3
  1. #1
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    146
    Thanked 156 Times in 149 Posts

    Formatting problem

    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?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Can you post an example?

  3. #3
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    146
    Thanked 156 Times in 149 Posts
    Not any more, see my last para. The formatted currency was as shown above - I cut and pasted it. I assume it was just one of those things.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •