| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Letter represents a number
If you have a larger list of letter-value combos, you might just want to
create a lookup table and then use a vlookup for the translation. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "JRD920" wrote: I would like to have a letter represent a number and to be able to calculate to get a sum. Example X= ".5" = 0.5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting time as 7.5 (which represents 7:30 AM) to 0730 | Excel Worksheet Functions | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Threaded Mode
