Thread: how to paste link and not get a zero in the blank cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how to paste link and not get a zero in the blank cell?
You cannot when you paste link.

To prevent a zero you must manually create the link.

=IF(Sheet1!A1="","",Sheet1!A1)

Or turn off the display of zeros in Display Options.


Gord Dibben MS Excel MVP


On Thu, 15 Oct 2009 09:13:37 -0700, Margo M <Margo
wrote:


Reply With QuoteReply With Quote