| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning a number value to text
Does anyone know how to get Excel to recognize a word as a numeric value? I
have gone into InsertNameDefine and assigned a numeric value to the word. Lets say the word is "Manager" and the value is "28.00". The job title and hourly wage. If I type "Manager' into a formula it will count it as 28.00, which is good, but if I refer to a cell that has "Manager' in it, it does not recognize it as a number. Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning number values to text strings | Excel Discussion (Misc queries) | |||
| Help assigning a number to a word | Excel Discussion (Misc queries) | |||
| Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
| Assigning a number value to a letter? | Excel Discussion (Misc queries) | |||
| assigning ranks to number ranges | Excel Worksheet Functions | |||
Threaded Mode
