Numeric Formatting when Mail merging with MS SQL 2000

[MP001]

I am doing a Mail merge document with SQL 2000 as my data source. Ther
are some Money fields which are coming on the Mail merge document, bu
whatever I do, they come with 4 decimal places. I have tried th
Numeric Switches \# #0.00, but to no avail.

Please Help

 

[Doug Robbins - Word MVP]

Try the following switch:

\# "$,0.00"

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

 

[MP001]

NO, the result is still the same..... 4 decimal places.

 

[Doug Robbins - Word MVP]

Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" }

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

 

[Paresh Gupta]

I keep getting
Invalid Character string.......

Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" }

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

NO, the result is still the same..... 4 decimal places.

 

[Graham Mayor]

Can you stick to the one thread please.

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


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

I keep getting
Invalid Character string.......

Try using { = { MERGEFIELD [fieldname] } * 1 \# "$,0.00" }

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

NO, the result is still the same..... 4 decimal places.


Doug Robbins - Word MVP;2816478 Wrote:
Try the following switch:

\# "$,0.00"

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

"MP001" (e-mail address removed) wrote in message

I am doing a Mail merge document with SQL 2000 as my data source.
There
are some Money fields which are coming on the Mail merge document,
but
whatever I do, they come with 4 decimal places. I have tried the
Numeric Switches \# #0.00, but to no avail.

Please Help.