topic Many null values in my numeric data causing issues? in ArcGIS for Office Questions https://community.esri.com/t5/arcgis-for-office-questions/many-null-values-in-my-numeric-data-causing-issues/m-p/757657#M11 <HTML><HEAD></HEAD><BODY><P>My spreadsheet contains a column of counts and rates.&nbsp; When the data is not statistically significant, the data originally had an * to indicate this.&nbsp; Because the column now contains characters, I am not able to use any of the styles that are based on numeric data.</P><P>I changed the cells to be 0 instead,&nbsp; plus I told Excel these are Numeric, but I'm still only able to see classification and single symbol.</P><P>Is there some trick for this?</P></BODY></HTML> Fri, 11 May 2018 21:47:53 GMT TracySchloss 2018-05-11T21:47:53Z Many null values in my numeric data causing issues? https://community.esri.com/t5/arcgis-for-office-questions/many-null-values-in-my-numeric-data-causing-issues/m-p/757657#M11 <HTML><HEAD></HEAD><BODY><P>My spreadsheet contains a column of counts and rates.&nbsp; When the data is not statistically significant, the data originally had an * to indicate this.&nbsp; Because the column now contains characters, I am not able to use any of the styles that are based on numeric data.</P><P>I changed the cells to be 0 instead,&nbsp; plus I told Excel these are Numeric, but I'm still only able to see classification and single symbol.</P><P>Is there some trick for this?</P></BODY></HTML> Fri, 11 May 2018 21:47:53 GMT https://community.esri.com/t5/arcgis-for-office-questions/many-null-values-in-my-numeric-data-causing-issues/m-p/757657#M11 TracySchloss 2018-05-11T21:47:53Z