Ask Your Question

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

asked 2019-02-07 11:27:09 +0200

BiG gravatar image


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 !

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-02-11 19:53:29.835509

1 Answer

Sort by » oldest newest most voted

answered 2019-02-07 12:07:06 +0200

erAck gravatar image

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

edit flag offensive delete link more


That's great trick ! 1 000 000 THANKS !

BiG gravatar imageBiG ( 2019-02-11 10:29:48 +0200 )edit

Question Tools

1 follower


Asked: 2019-02-07 11:27:09 +0200

Seen: 329 times

Last updated: Feb 07 '19