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://answers.microsoft.com/en-us/msoffice/forum/all/word-2010-quick-part-document-property-formatting/53ad12d2-2843-402a-815d-e97c72f05d03 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.
5 Replies
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.
