Prevent Zero Values being Suppressed in a Mail Merge

		Microsoft Office Forums > Microsoft Word > Mail Merge
Prevent Zero Values being Suppressed in a Mail Merge

12-11-2013, 02:28 PM

macropod

Windows 7 32bit Prevent Zero Values being Suppressed in a Mail Merge

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

Perhaps better still is:
\# £,0.00
Using '\# £#,##0.00' forces Word to insert spaces before values less than £1,000.00.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loss of formulae values when mail merging excel to word	MellowMel	Mail Merge	6	05-09-2014 09:08 AM
Content control merge values?	skrallemand	Word VBA	8	10-02-2013 06:54 AM
Mail Merge Duplication of address on merge	RICKY	Mail Merge	1	09-26-2012 03:14 PM
Any way to prevent mail appearing as read after opening from a desktop alert?	pumpkin_feet	Outlook	0	10-24-2011 06:55 AM
Can Save As dialog be suppressed?	dug_down_deep	PowerPoint	0	10-05-2010 09:46 AM

Other Forums: Access Forums

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