Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2010
    Location
    Tulsa, OK
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am having this exact same issue, except I need to format a document property, not a merge field. The document property is a SharePoint column and is populating correctly in the document panel, but when shown in the body of the document, no comma, decimal, or $ is displayed. Any ideas?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by Roxanne Whiteis View Post
    The document property is a SharePoint column and is populating correctly in the document panel, but when shown in the body of the document, no comma, decimal, or $ is displayed.
    I'm a little concerned about the decimal point. That's not just a question of formatting, but involves actual math.

    I do not use SharePoint, so I'm not sure how this property differs from any other, but let's say for example you have a custom document property named BottomLine which has a value of 123456.78 (number, not text). You can format it as currency by adding the switch listed in macropod's post:

    DOCPROPERTY BottomLine \# "$,0.00;($,0.00);'-'"

    (Select the field, press Shift+F9, then edit, then press F9 to refresh and view the result.)

    Does that work for your property?

Posting Permissions

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