Select to view content in your preferred language

Many null values in my numeric data causing issues?

258
0
05-11-2018 02:47 PM
TracySchloss
Honored 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