Numbers and Letters

[oberon.black]

I am creating a spreadsheet that will contain cells with the following:

A, B, C, D, E
I need these letters to equal

5, 4, 3, 2, 1
So that when I create charts I can plot using the letters (gradescale)


so I could get data like a 3000 fence made of grade "A" materials wil
last say 5 years.

and that no matter what I plot the letters A,B,C,D,E will always equa
5,4,3,2,1.

How can this be done? Please help.

Thank

 

[Dana DeLouis]

If I understand the question, if A1 contains the text "A", then perhaps:
=70-CODE(A1)

Since the character code for "A" is 65 (B is 66, etc)
HTH
--
Dana DeLouis
Win XP & Office 2003


"oberon.black" <[email protected]>
wrote in message
news[email protected]...