[MP001]

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.




--
MP001

[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" 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.




--
MP001

[MP001[_2_]]

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




--
MP001 -




--
MP001

[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

"MP001" wrote in message
...

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




--
MP001 -




--
MP001

[Paresh Gupta]

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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...

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




--
MP001 -




--
MP001

[Graham Mayor]

Can you stick to the one thread please.

--

Graham Mayor - Word MVP

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



Paresh Gupta wrote:
I keep getting
Invalid Character string.......


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...

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




--
MP001 -




--
MP001