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?
|