View Single Post
 
Old 08-16-2021, 05:07 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default 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
Reply With Quote