Results 1 to 3 of 3
  1. #1
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,852
    Thanks
    152
    Thanked 176 Times in 169 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,852
    Thanks
    152
    Thanked 176 Times in 169 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
  •