Why are some imported cells changing to zero?

[Guest]

I am trying to import info on some cells to another worksheet. I type = in
the destination sheet and click the cell I want from the original sheet but
the number is coming up as 0 in the destination cell. Some of the cells I do
this with are fine and others will give me 0.

 

[Guest]

Perhaps you were referring to this ..

In Sheet1,

Instead of having in say A1: =Sheet2!A1
with A1 copied across / filled down,

Put it in A1 as : =IF(Sheet2!A1="","",Sheet2!A1)
then do the copy across / down

The above will allow Sheet1 to appear neatly "blank"
if the linked cells in Sheet2 are blank