Why are some imported cells changing to zero?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amy Ryan - 18 Oct 2006 15:29 GMT

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.

Reply to this Message

Max - 18 Oct 2006 16:47 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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.

Reply to this Message