This may work...

  Simsy 12:01 15 Nov 2004

it tells Excel to display nothing, (i.e. a blank cell), when the result of a calculation is zero.

Tools>Options>View and UNtick the "Zero Values" option.

This should certainly make it lookcorrect in Excel, but I'm not sure what will be carries over to a mail merge; it might still carry the value over, i.e. "0"

Good Luck,

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Book 2: Release date, price and specs

Adobe's groundbreaking prototypes of new features and apps for Creative Cloud

When is the next Apple event?

Les meilleurs VPN gratuits (2018)