I am performing the simple task of creating shapefiles from XY tables using some Excel spreadsheets and am having problems with the symbology. Each time I try to classify using unique values, I get a set of delimited values that are not in the Excel file and they are not showing up in the attribute tables. I have manually re-typed the entire Excel file and have had the same problem. The first column has commas within the text file, so I tried deleting the commas (and the column completely at one point) and the same problem persists. I had no problems with one sheet from the same file, but this specific sheet has me baffled. Does anyone know how to rectify this problem or any possible solutions I could try? I have attached a screen shot to show what is happening. Thanks, Reed
... View more