Numeric Formatting when Mail merging with MS SQL 2000

P

Paresh Gupta

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
 
B

Bob Buckland ?:-\)

Hi Paresh Gupta,

I'm assuming you're using Word to do your merge. If so, you may want to also post in the Word Mailmerge discussion group through
the link below and include the version of Word you're using.

============
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 >>
--
Bob Buckland ?:)
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends*

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.mailmerge.fields
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.mailmerge.fields

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Formatting when Mail merging with MS SQL 2000 5
Merging from an Excel file with graphics 1
Mail Merge with SQL 2000 10
Mail Merge - displaying a conditional number of decimals 5
ASK Field Formatting 1
Page numbering with Merged Document and IF statements 1
Mail Merge query 1
Mail Merging Content With High Quality 1

Top