2010-05-20, 12:49 #1
- Join Date
- May 2010
- Tulsa, OK
- 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?
Subscribe to our Windows Secrets Newsletter - It's Free!
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!
+ 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!
2010-05-20, 17:04 #2
- Join Date
- Feb 2001
- Silicon Valley, USA
- Thanked 93 Times in 89 Posts
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?