Forum Discussion
madwal2
Jun 29, 2023Copper Contributor
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:...
Jun 29, 2023
madwal2 What does simply { QUOTE "[QuickPart]" }? If that does return the unformatted number, you could use { = 1 * { QUOTE "[QuickPart]" } \# $,0.00 }
- madwal2Jun 29, 2023Copper Contributor
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.
- Jun 30, 2023
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.
- madwal2Jul 05, 2023Copper ContributorI think for some reason the formatting is just not capable of applying to quick parts.