Why are some imported cells changing to zero?
 

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.

Why are some imported cells changing to zero?
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amy Ryan" wrote:
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.