View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Can I show text that represents a number

I want to take a table that shows text in a column for several rows, but the
text in each row represents a number that I can average?
Here's the table - If I want the A+ to represent a number when O enter A+,
how do I do that?:
A+ 4.5
A 4
B+ 3.5
B 3
C+ 2.5
C 2
D+ 1.5
D 1
F 0