Currency formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PaddyWack - 23 Apr 2008 23:33 GMT

I have a project that I maintain for a client.

It uses Word merge documents that have dynamic text based on user
input.

The problem is that when merge fields are formatted as currency and the
dynamic text moves the fields to the right margin, the "$" is often
separated from the value.

So the client gets output with "$" at the right margin and the value
starting on the next line.

Any ideas?

Signature

PaddyWack

Reply to this Message

Graham Mayor - 24 Apr 2008 11:00 GMT

Are you using a currency switch on the field eg

{Mergefield Fieldname \# "$,0.00"}

The field should then stay together.

Signature

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

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

> I have a project that I maintain for a client.
>
[quoted text clipped - 9 lines]
>
> Any ideas?

Reply to this Message

Doug Robbins - Word MVP - 24 Apr 2008 11:08 GMT

How is the amount being formatted as currency. If you add the following
formatting switch to the merge field, you will not get a break between the $
and the amount.

\# "$,0.00"

If you want a space between the $ and the amount, you should use a
not-breaking space (Ctrl+Shift+Space), either in the formatting switch, or
if the $ is entered directly into the document, between it and the merge
field.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I have a project that I maintain for a client.
>
[quoted text clipped - 9 lines]
>
> Any ideas?

Reply to this Message

PaddyWack - 24 Apr 2008 18:06 GMT

Was using {MERGEFIELD XYZ \# $#,###}.

Making that {MERGEFIELD XYZ \# $,###} seems to have done the trick, s
long as that handles values >= $1,000.

Thanks. Now I can get out of word processor mode and go back t
software development.

Doug Robbins - Word MVP;2738806 Wrote:

> How is the amount being formatted as currency. If you add the followin
>
[quoted text clipped - 25 lines]
>
> Any ideas?

--
PaddyWack

Reply to this Message

Graham Mayor - 25 Apr 2008 07:15 GMT

If you only want whole numbers, the correct switch would be

{MERGEFIELD XYZ \# "$,0" }

Signature

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

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

> Was using {MERGEFIELD XYZ \# $#,###}.
>
[quoted text clipped - 46 lines]
>> --
>> PaddyWack -

Reply to this Message