Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
How do I display hyperlink in Excel cell? | Excel Discussion (Misc queries) | |||
display the value of a cell adjacent to the cell with max value | Excel Worksheet Functions | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel |