An alternative to Ron's suggestion is to format the cell using Currency or
Accounting formats. These still leave the cell's value as zero, but display
a hyphen.

"Cube Farmer" wrote:

='Accounts Payable'!L3

I want this formula to show - if it is "0" .
The Accounts Payable L3 is also a formula.
Is an if error required?

Thanks for any help.