Can we return an empty cell instead of Zero by keeping the formula?


I would like to copy (on calc) and paste (in my mailbox) a list of mails that has been generated by a Paste Special with the option “Link” checked.

The problem is that when the referring cell is empty, the “linked” cell returns a zero.

The result: the copied email list contains mails and zeros.

(Note: On Calc, “Paste Text Only” allows omitting zeros when pasting.)

Thank you all for your help !

You can apply this number format [=0]"";General meaning if numeric value is 0 then display empty string, otherwise display result in General format.

That’s great trick !
1 000 000 THANKS !