How do you put a blank into a space that also registers as a number value?

[mdershew]

You would think this would be easy but its not. I have a column of percentages that shows annual change in items. Given that there are a lot of new items and dropoff items, I want to leave those percentage changes blank. However, I also want to filter on these percentages. I put in error handling that sets values to "" if one of the two columns is a zero, however later when I filter this percentages column, all "" are recognized as text, not numbers. My question is - how do I put a null value into a cell that also registers as a number for filters? "" is not working....thanks all

 

[Norie]

You could set the formatting for the column so that cells that have 0 values appear blank.

 

[SpillerBD]

It is likely your first cells in that columns have the "" value, which is text and the filter assumes that.
You have to fail-over to a value.

 

[FDibbins]

"" is text, not value, that's why that is happening. I think Norrie's suggestion is probably the way to go.

Or, along the same lines, use Conditional Formatting to set the font color to be the same as the background color?