Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Christchurch, New Zealand
    Posts
    250
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Currency format in table fields

    I have a Word 2010 table, and a calculation {=sum(above)\#$#,##0.00}. The problem I have is if the answer is below $1,000.00 then there is a space after the $ sign, eg: $ 500.00. I really want the dollar sign to be hard up against the text.

    Any ideas?

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Karen,

    This is really simple:
    {=sum(above)\# "$,0.00"}.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Christchurch, New Zealand
    Posts
    250
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you sooooo much. You won't believe how frustrating an extra space can be

Posting Permissions

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