| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I incorporate letters as numbers in a formula?
On a roster, D = 12 hour day and N = 12 hour night. How do I get Excel to
calculate D's and N's as numbers? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I incorporate letters as numbers in a formula?
Hi,
Somewhere out of the way do this Insert|Name|Define Enter D In another cell Insert|Name|Define Enter E Put the number 12 in each of these cells You can now refer to D & E and they will be treated like values. i.e. =D+E returns 24 Mike "MWRhino" wrote: On a roster, D = 12 hour day and N = 12 hour night. How do I get Excel to calculate D's and N's as numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula help - incorporate greater than & smaller than | Excel Worksheet Functions | |||
| Way to Incorporate Trim Into Match/Index Formula | Excel Worksheet Functions | |||
| How do I convert numbers (quantities) en letters with a formula? | Excel Discussion (Misc queries) | |||
| formula with letters and numbers | New Users to Excel | |||
| How do I count letters and numbers in a formula? | Excel Worksheet Functions | |||
Linear Mode
