Pasting Links

[spaz9876]

I created a sheet that links a quantity column to another sheet within the same workbook (so I can hide the one sheet with confidential information).
The links work but it shows a "0" in every cell that is blank on the confidential sheet. I want to be able to filter by "non blanks" as I have headings that I put a"." in so they show up. Is it possible not to show "0"s?

[Jacob Hilderbrand]

Tools | Options | Zero Values

Or


=If(MyFormula = 0, "", MyFormula)

[mdmackillop]

or you could try a Custom Format such as:

0.00;-0.00;""

[spaz9876]

Thank you - that last one worked!

[spaz9876]

Ok an issue with this.... some of the cells we want to put a character in so that it shows up in the filter but when we do this, it changes the other column to "#VALUE!" We used to use "0" but now that the linked tab hides the "0s" in order for the link to not show "0s" all the way down the column, we can't use them anymore to show optional items.
Qty Unit Price Extended Price
1 $130 $130
0 $925 $ -
O $25 Value

[mdmackillop]

Can you post a sample of your spreadsheet?