Hi Cube
You can use IF
=IF('Accounts Payable'!L3=0,"-",'Accounts Payable'!L3)
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Cube Farmer" wrote in message ...
='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.