Numeric Formatting when Mail merging with MS SQL 2000

M

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
 
D

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
 
D

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
 
P

Paresh Gupta

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


Doug Robbins - Word MVP said:
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

MP001 said:
NO, the result is still the same..... 4 decimal places.
Click to expand...
Click to expand...
 
G

Graham Mayor

Can you stick to the one thread please.

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


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


Paresh said:
I keep getting
Invalid Character string.......


Doug Robbins - Word MVP said:
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

MP001 said:
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" [email protected] 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.
Click to expand...
Click to expand...
Click to expand...
 
Top