Thread: Paste Link enters a 0 into the cell where I paste. How do I elemin
View Single Post
  #2   Report Post  
Ramakrishnan Rajamani
 
Posts: n/a
Default
Tools - Options - View

Uncheck the box next to Zero Values

"UNR" wrote:

When I use Paste Link the cell that I link to shows a 0 iin the cell if there
is no data in the cell it is linked to. How do I eleminate the 0. I want the
cell to be null if there is no data.
Reply With QuoteReply With Quote