Hide/Don't Display Values
=IF(Primary!A1<"",Primary!A1,"")
etc.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Mike" wrote in message
...
I have a secondary spreadsheet that obtains its values (text and numbers)
from a primary spreadsheet. Since some of the values in the primary
spreadsheet are blank, the secondary spreadsheet displays "0" for blank
text
and $0.00 for blank numbers.
How do I hide these values in the spreadsheet, without losing the
formulas?
I want to make sure that the values can be seen in the secondary
spreadsheet
in the future if any valid values are entered.
Thank you.
|