Forum Discussion
Format QuickPart as Currency
Hi,
I am currently passing a currency value from Sharepoint to a word document through quick parts.
The value is a currency everywhere except for on the document. I found this on web https://social.msdn.microsoft.com/Forums/office/en-US/de2272f1-0c03-43a4-8bc9-78917cc5992d/format-quick-part-document-property-received-from-sharepoint but its from 12 years ago.
I used ctrl-F9 to insert a pair of field code braces { } and then { QUOTE "[QuickPart]" \#$,0.00 }.
Does anyone have any suggestions? I really don't want to store the number as text in sharepoint for analytics reasons but the user I'm building it for really needs it displayed correctly on the document.
madwal2 What does simply { QUOTE "[QuickPart]" }? If that does return the unformatted number, you could use { = 1 * { QUOTE "[QuickPart]" } \# $,0.00 }
Yes getting a syntax error. It looks like its not recgonizinging the quick part at all. I.e. not pulling in the number.
I ran it through below. I put two quick parts and filled it in on the first (it normally replaces) and then just put a second one after to test. It is passing to the second but it not passing to the quick part in the formatting brackets for some reason.
madwal2 I am not sure to what it was that displayed a result where you say: "It is passing to the second"
Have you tried enclosing what ever that is inside field delimiters together with
{ = 1 * ???? \# $,0.00 }
where the ???? represents whatever it was.
