Hide/Don't Display Values
 

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.

Hide/Don't Display Values
 

=IF(Sheet2!A1="","",Sheet2!A1)


--


Regards,


Peo Sjoblom


"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.

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.

Hide/Don't Display Values
 

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.

Hide/Don't Display Values
 

Thank you so much. Works great!

"Peo Sjoblom" wrote:

=IF(Sheet2!A1="","",Sheet2!A1)


--


Regards,


Peo Sjoblom


"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.