Merge Field Ignoring Zeros

		Microsoft Office Forums > Microsoft Word > Mail Merge
Merge Field Ignoring Zeros

FAQ

Thread Tools

Display Modes

05-04-2012, 01:56 AM

Welshie82

Windows 7 32bit Merge Field Ignoring Zeros

Office 2007

Advanced Beginner

Join Date: Oct 2011

Location: Birmingham

Posts: 33

Quote:

Originally Posted by macropod

Your field switch effectively says to only output non-zero decimals. If you use:
{MERGEFIELD amount \# ,0.00}
you will get all decimals to two places, and amounts of one thousand and over with thousand separators.

Wonderful, that worked! Thank you Macropod, as always.

Tags

excel 2007, merge field, word 2007

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Character Count in Merge Field	deddy	Mail Merge	3	10-20-2011 02:20 AM
Toggle Merge Field Code Help Please	tonywatsonmail	Mail Merge	2	08-11-2011 07:06 AM
confusion with merge and field codes	BluRay	Mail Merge	5	03-29-2011 01:06 AM
Merge field in header disappearing	Medievalguy88	Word	2	01-06-2011 08:19 AM
Mail merge Field Code Manipulation	macjnr	Mail Merge	0	09-10-2009 11:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 PM.