Friday, May 1, 2009

Mail Merging numbers with decimals - MS Word

When using Excel spreadsheets in a mail merge process, you may run into difficulty formatting the fields that contain number values. Irrespective of number and decimal format you choose in excel, merged MS-word fields doesn't reflect the format and MS-Word does not provide a way for you to change how many decimal places are displayed when working with numbers.

Here is a easy solution:

To specify how many decimal places to display in your Word mail merge, you can use the Numeric Picture Field Switch (\#):
1. With the mail merge main document open, press Alt + F9 to view the field codes
2. The field code will look something like {MERGEFIELD “fieldname” }
3. Directly after the end quote around the field name type \# -- do not add spaces or quotes
4. Directly after the field switch you just entered, type 0.0x if you want to round the number to two decimal places, 0.00x if you want to round the number to three decimal places and so forth
5. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes
Your number will appear rounded to the decimal place you specify; if it does not display immediately, refresh the document by minimizing it to the toolbar and reopening. If the field value still does not display correctly, you may need to refresh the document again or close and re-open your document.

5 comments:

Vivek said...

no updates on the blog? biji biji haan?

Anonymous said...

I was extremely pleased to uncover this great site. I need to
to thank you for your time due to this wonderful read!
! I definitely really liked every little bit of it and i also have
you saved as a favorite to look at new things in your site.

refinishing hardwood floors

My web page engineered hardwood flooring

Anonymous said...

Hi there! This blog post couldn't be written any better! Reading through this post reminds me of my previous roommate! He continually kept talking about this. I am going to send this information to him. Pretty sure he's going to have a great read.
Thanks for sharing!

Here is my web-site; cleaning services phoenix
my webpage > phoenix house cleaning

Anonymous said...

An outstanding share! I've just forwarded this onto a co-worker who has been doing a little research on this. And he in fact ordered me breakfast because I found it for him... lol. So allow me to reword this.... Thank YOU for the meal!! But yeah, thanx for spending some time to talk about this subject here on your website.

Also visit my site click the up coming website
my web site > click through the next webpage

Anonymous said...

I'm very happy to find this page. I want to to thank you for your time due to this wonderful read!! I definitely loved every little bit of it and I have you book marked to check out new things on your web site.

My web page provillus review