Many null values in my numeric data causing issues?

148
0
05-11-2018 02:47 PM
TracySchloss
Frequent Contributor

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?

0 Kudos
0 Replies