View Single Post
  #1   Report Post  
oberon.black
 
Posts: n/a
Default Letters = Numbers


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 will
last say 5 years.

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

How can this be done? Please help.

Thanks


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=484119