My spreadsheet contains a column of counts and rates. When the data is not statistically significant, the data originally had an * to indicate this. Because the column now contains characters, I am not able to use any of the styles that are based on numeric data.
I changed the cells to be 0 instead, plus I told Excel these are Numeric, but I'm still only able to see classification and single symbol.
Is there some trick for this?