Mail merge field help for percentage null values

		Microsoft Office Forums > Microsoft Word > Mail Merge
Mail merge field help for percentage null values

FAQ

Thread Tools

Display Modes

08-16-2021, 05:07 AM

ganesang

Windows XP Mail merge field help for percentage null values

Office 2016

Competent Performer

Join Date: Jul 2018

Posts: 170

Mail merge field help for percentage null values

Hi Guys

I need your help to generate as empty if cells empty in excel mail merge.

I have used the below field but return as 0.00% instead of empty.

{ =0*100 \# "0.00%" }

If cells have values then above field code working fine but if nothing in excel cell return as 0.00%. So please help out on this issue

My field code name is "Prod Quality_".

thanks
Ganesan. G

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
text-to-Fields failing - how get null for missing values?	guthrie	Excel	8	06-09-2016 08:36 PM
Display Null Values in Pivot as 0	lornalou	Excel	2	06-02-2016 10:39 AM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM
formating a percentage in a Mail Merge	dkalsow	Mail Merge	3	04-03-2012 03:38 PM
Eliminating zeros, null values and negatives in a column	jannie	Excel	1	06-22-2011 07:03 PM

Other Forums: Access Forums

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