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. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #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
  •