Paste Link unwanted zeros

Posted by Tom Urtis on January 25, 2001 4:43 PM

In Excel 2000, I have paste linked cells that contain text. In the destination file, a zero ("0") appears when the linked cell in the source file is blank. Is there any way to keep from getting those ugly 0's in the destination file if nothing exists in the linked source file cell. Cells are all formatted the same (General). Thanks.

Posted by cpod on January 25, 2001 4:53 PM

You could turn off the Zero Values option:
Tools=> Options -> View

Posted by Dave Hawley on January 25, 2001 6:37 PM

Hi Tom

You could also use =IF(A1="","",A1)

This would return Empty text if A1 was empty.

Hope this helps

Dave

OzGrid Business Applications