Consider an easy way?
Just suppress the display of zeros in the sheet via:
Tools Options View tab
Uncheck "Zero values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mike" wrote:
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.