Reply to thread

Message: [QUOTE="Laurence Smith, post: 7415488"] This should be so easy but I can't figure out how to do it. In rating players for a Fantasy Draft I have a small lookup table. When I rate a player a "2-" for instance I want the numerical equivalent in my rating system to be 4. The lookup table works fine for players rated with a minus or a plus, like 2- or 3+, but I get the dreaded NA when I have rated a guy 1, 2, 3, 4 I assume that Excel sees that as a number, not as text. Is there a way to get it to see it as text? Just doing a format of the column doesn't get it done. Thanks. [/QUOTE]