When i paste link i get zeros in all empty cells. Can i prevent this? Anybody?
K Khartoum Sep 28, 2006 #1 When i paste link i get zeros in all empty cells. Can i prevent this? Anybody?
K Khartoum Sep 28, 2006 #2 I have tried using the skip blanks option but this then disables the paste link option. Confused!
G Gord Dibben Sep 28, 2006 #3 You can go to Tools>Options>View and uncheck "zero values" Or write a formula rather than use the "paste link" =IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP
You can go to Tools>Options>View and uncheck "zero values" Or write a formula rather than use the "paste link" =IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP
K Khartoum Sep 29, 2006 #4 Thanks Mate! Gord Dibben said: You can go to Tools>Options>View and uncheck "zero values" Or write a formula rather than use the "paste link" =IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP Click to expand...
Thanks Mate! Gord Dibben said: You can go to Tools>Options>View and uncheck "zero values" Or write a formula rather than use the "paste link" =IF(Sheet1!A1="","",Sheet1!A1) Gord Dibben MS Excel MVP Click to expand...
