|Subject:||hiding 0 from a cell|
|Date:||Mon, 29 Jan 2007|
I can't figure out why this doesn't work, I keep getting circular references.
i have 3 workbooks. 1 is a summary linked to other 2 which are stored in a
different drive. The summary is I:\abc\etc\[summary.xls]sheet 1'!$d$6).
At the moment the cell inwhich this reference sits has 00:00 which is
mm:ss. I want this cell to remain empty until the cell from which it is
linked is populated with a figure.
The response is "the formula you typed contains an error etc etc.
I followed what I thought I had to but no joy.
Any help would be appreciated,