| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| understanding what part of a formula represents | Excel Worksheet Functions | |||
| Letter represents a number | Excel Discussion (Misc queries) | |||
| Converting time as 7.5 (which represents 7:30 AM) to 0730 | Excel Worksheet Functions | |||
| grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
| Taking out string part which represents date | Excel Worksheet Functions | |||
Threaded Mode
