| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
assign a number value to a text. ie, PL equals .5
I'm creating a estimating template. I would like to assign the text of "PL"
a number value of .55. This would help in not having to enter .55 in an additional cell for calculation. "Gary''s Student" wrote: Put the .5 in an un-used cell. Select the cell and then pull-down: Insert Names Define and enter plate then click add and click ok. You can then use the name in a formula: =plate*12.345 -- Gary's Student "JWDesigns" wrote: I'm using different material "plate, angle, tube steel" I would like to assign a number value to that text. ie. plate would equal .5 Is there a way I can do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
| Change number format from text to number? | New Users to Excel | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| PREVENT conversion of text to number? | Excel Discussion (Misc queries) | |||
| Conversion of a Number into English Text | Excel Worksheet Functions | |||
Threaded Mode
