Currency formatting

[PaddyWack]

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?

 

[Graham Mayor]

Are you using a currency switch on the field eg

{Mergefield Fieldname \# "$,0.00"}

The field should then stay together.

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


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

 

[Doug Robbins - Word MVP]

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.

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

 

[PaddyWack]

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.

 

[Graham Mayor]

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

{MERGEFIELD XYZ \# "$,0" }

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


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