Try changing the format to Custom ;;""
That tells Excel to display zero's as "".

"Babylooch" wrote:

I am looking up values in a Pivot Table. If the value is null, the formula
is displaying zero instead of null. Is there a way to display null when null
and zero when the value is zero?