If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell display
I created a workbook that has a summary page with cells that link to cells in
other pages of the workbook. These cells are in date format. When there is no entry in the cells of the other pages, the summary page cell shows 1/01/1900. I would like the cell on the summary page to be blank if the linked cell is blank. Does anyone know how to do this? -- Thanks |
#2
|
|||
|
|||
Cell display
One way to do it (if it doesn't conflict with some other requirement
that you might have) ... Turn off display of zero values by going Tools / Options and clearing the tick next to Zero Values. Rgds, ScottO "Nuts" wrote in message ... | I created a workbook that has a summary page with cells that link to cells in | other pages of the workbook. These cells are in date format. When there is | no entry in the cells of the other pages, the summary page cell shows | 1/01/1900. I would like the cell on the summary page to be blank if the | linked cell is blank. Does anyone know how to do this? | -- | Thanks |
#3
|
|||
|
|||
Cell display
=IF(Linked_Cell="","",Linked_Cell)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Nuts" wrote in message ... I created a workbook that has a summary page with cells that link to cells in other pages of the workbook. These cells are in date format. When there is no entry in the cells of the other pages, the summary page cell shows 1/01/1900. I would like the cell on the summary page to be blank if the linked cell is blank. Does anyone know how to do this? -- Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
display a drop-down list based on the content of another cell | Joe S | General Discussion | 6 | December 6th, 2005 12:23 AM |
large text amount in cell will not display in the cell | dbelch01 | General Discussion | 3 | June 15th, 2005 03:43 PM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Display one number in a cell even though 2 numbers get pasted into the same cell? | DrSues02 | General Discussion | 2 | October 4th, 2004 11:16 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |