Return blank cell

[benswelding]

Hi
I use the the copy past link to enter information automaticaly from one cell to another.The problem is if the original cell is blank it returns 0 in the destination cell .Is there a formula I can use to leave destination cell blank.
Thanks in advance

[arthurbr]

Try =if(original_cell="","",original_cell_value) in the destination cell

Or Go to Tools - Options - View tab - Uncheck "zero values"