Hide/Don't Display Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=IF(Primary!A1<>"",Primary!A1,"")

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Consider an easy way?
Just suppress the display of zeros in the sheet via:
Tools > Options > View tab
Uncheck "Zero values" > OK
 
Back
Top