I am trying to colorize (quantify) a chloropleth map based on rent price data in ArcMap 10.2.1. The rent price value is from my .xlsx excel table, which is joined with my shapefile. However, the rent price value is missing from the drop-down list of values under the symbology tab. I know that the data was joined without any errors, so I'm not sure why I'm not able to color-code my map based on the rent price data.
Does anyone have an idea what I am missing?
EDIT: The rent price was listed as a string value and so I added a new numeric field to the attribute table of the census tract shapefile (shown below), but I'm not sure how to get the values from the string column into the numeric column.