Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers and Letters
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 -- oberon.blac ----------------------------------------------------------------------- oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673 View this thread: http://www.excelforum.com/showthread.php?threadid=48411 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numbers and Letters
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" wrote in message news:oberon.black.1yaxzo_1131661503.4974@excelforu m-nospam.com... 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=484118 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
create self-generating numbers with letters and numbers | Excel Discussion (Misc queries) |