Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Pasting a formula in multiple cells without changing the range | Excel Discussion (Misc queries) | |||
Resize individual cells w/o changing the entire column width | Excel Discussion (Misc queries) | |||
Literally displaying imported cells with and tags | Excel Discussion (Misc queries) | |||
Changing Colors of Cells | Excel Worksheet Functions |