MERGEFIELD - Numeric Picture

MERGEFIELD - Numeric Picture - Insert decimal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brenda - 19 Feb 2006 15:11 GMT

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

Reply to this Message

Graham Mayor - 19 Feb 2006 15:39 GMT

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"}

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a mergefield whose value is 123456 which I want to display as a
> currency field $1,234.56.
[quoted text clipped - 5 lines]
>
> Brenda

Reply to this Message