MERGEFIELD - Numeric Picture - Insert decimal

[Brenda]

I have a mergefield whose value is 123456 which I want to display as a
currency field $1,234.56.

I have the same problem with numeric fields. The value in my datasource is
123456 and I want to display as 1,234.56

What Numeric Picuture of function can I use to accomplish this?

Brenda

 

[Graham Mayor]

You can't do it with a switch alone. You will have to use a formula field to
divide by 100 to set the decimal point.
{=({Mergefield fieldname} / 100) \# "$,0.00"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>