Linking Problems
 

I am trying to link some columns using the Paste Special to another
worksheet in my workbook. When I link them, all of the blanks in the
original show up as 0's in the link. If I just delete the 0's, then
the link is also deleted, but I want the cells to still be linked. I
am trying to create a scheduling list, and so I need to see all of the
rows, and see where dates have yet to be entered. How do I make the
blanks from the original show up in the link blank? If there is a
command within a formula for this, how do I apply it to an entire
column? I don't want to just hide the rows with 0's. I am a novice
excel user, so I apologize if this is a dumb question. Any help would
be appreciated. Thanks.


--
sbeninga
------------------------------------------------------------------------
sbeninga's Profile: http://www.officehelp.in/member.php?userid=240
View this thread: http://www.officehelp.in/showthread.php?t=696366
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.php

If you don't want to see *any* zeros at all on this worksheet,
go Tool/Options and on the View tab click off the tick next to Zero Values
(it's at the middle low down on the Tab).
Click OK.
All those ugly zeros should now be gone.
Rgds,
ScottO

"sbeninga" wrote in message
...
|
| I am trying to link some columns using the Paste Special to another
| worksheet in my workbook. When I link them, all of the blanks in the
| original show up as 0's in the link. If I just delete the 0's, then
| the link is also deleted, but I want the cells to still be linked. I
| am trying to create a scheduling list, and so I need to see all of the
| rows, and see where dates have yet to be entered. How do I make the
| blanks from the original show up in the link blank? If there is a
| command within a formula for this, how do I apply it to an entire
| column? I don't want to just hide the rows with 0's. I am a novice
| excel user, so I apologize if this is a dumb question. Any help would
| be appreciated. Thanks.
|
|
| --
| sbeninga
| ------------------------------------------------------------------------
| sbeninga's Profile: http://www.officehelp.in/member.php?userid=240
| View this thread: http://www.officehelp.in/showthread.php?t=696366
| Visit - http://www.officehelp.in |
http://www.officehelp.in/archive/index.php |
http://www.officehelp.in/index/index.php
|

You can format the cells so that zeros don't appear.
Select the column
Format / Cells / Number / Custom / d-mmm-yyyy;;

(or substitute your prefered number format for d-mmm-yyyy. The
important part are the two ";" which ensure negative and zero values
are not shown.

Or you could use d-mmm-yyyy;;"-" for example, to see a - rather than a
0 in the cells.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thank you both very much, the problem is solved and it's all working
smoothly.


--
sbeninga
------------------------------------------------------------------------
sbeninga's Profile: http://www.officehelp.in/member.php?userid=240
View this thread: http://www.officehelp.in/showthread.php?t=696366
Visit - http://www.officehelp.in | http://www.officehelp.in/archive/index.php | http://www.officehelp.in/index/index.php