| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert a letter to a number
Here's how my graph is
a b c d e 1 L L L 2 L L L L 3 L L 4 L L L 5 L 6 30 20 20 30 30 How do I get the L's to represent $10.00 but still have the L in the graph then when I add them i show the L's added up as numbers? Basically, what formula will help me get the added sums of L's in numerical form like in row 6 in my graph? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
| Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
| Is it possible to convert a number into hours and minutes | Excel Worksheet Functions | |||
| Count number of cells that contain a certain letter - Case Sensitive | Excel Discussion (Misc queries) | |||
| How do I convert a given number into a letter? | Excel Worksheet Functions | |||
Threaded Mode
