I have a column in my .dbf file that is a mixture of gradually increasing numbers but also a word for all of the items that don't match the criteria, for example:
**JUNIOR_PRI,N,4,2** 3.9 2.44 1.38 2.73 0 Non Non 0
I didn't want to make the 'Non's a number, because then it would throw off my graduated color ramp if it took those into account; that's why I wanted to have the numbers ramp from yellow to blue, and then make the 'Non's all the same color -- like red. But when it goes into the GIS attribute table, it resets all my 'Non's to zeros. Is that because you can't mix numbers/words in a column?
And is it possible to do my initial thought -- or would I have to make another column with all the 'Non's in that one so I could overwrite the blanks from my "JUNIOR_PRI,N,4,2" column?