Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Designate a number with letters?
Winter Delta T = 82 Deg. F
Heating Design Degree Day = 6493 heating degree-days In a work sheet, there are calculations that designate the letters dt or dd as the number 82 or 6483. EX: Btu/h =D9*E9*DT Btu/h 352,469 Or just: when you type =DT in a cell, the number 82 is put into that cell in the work sheet. I would much appreciate it if some one can help me understand how this is done so I can replicate this in the future. Thanks, Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Designate a number with letters?
Hi,
Try selecting a cell then Insert|Name|Define Name the cell DeltaT Click OK You can then put a value in that cell and perform calculations =100*DeltaT Mike "dgb82" wrote: Winter Delta T = 82 Deg. F Heating Design Degree Day = 6493 heating degree-days In a work sheet, there are calculations that designate the letters dt or dd as the number 82 or 6483. EX: Btu/h =D9*E9*DT Btu/h 352,469 Or just: when you type =DT in a cell, the number 82 is put into that cell in the work sheet. I would much appreciate it if some one can help me understand how this is done so I can replicate this in the future. Thanks, Don |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Designate a number with letters?
I just noticed I've wasted my time you have several answers in you other
thread. Don't multi post its irritating for those who give their time freely to answer. Mike "Mike H" wrote: Hi, Try selecting a cell then Insert|Name|Define Name the cell DeltaT Click OK You can then put a value in that cell and perform calculations =100*DeltaT Mike "dgb82" wrote: Winter Delta T = 82 Deg. F Heating Design Degree Day = 6493 heating degree-days In a work sheet, there are calculations that designate the letters dt or dd as the number 82 or 6483. EX: Btu/h =D9*E9*DT Btu/h 352,469 Or just: when you type =DT in a cell, the number 82 is put into that cell in the work sheet. I would much appreciate it if some one can help me understand how this is done so I can replicate this in the future. Thanks, Don |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Designate a number with letters?
Sorry about that Mike.
Also, I was woundering if you work for microsoft? "Mike H" wrote: I just noticed I've wasted my time you have several answers in you other thread. Don't multi post its irritating for those who give their time freely to answer. Mike "Mike H" wrote: Hi, Try selecting a cell then Insert|Name|Define Name the cell DeltaT Click OK You can then put a value in that cell and perform calculations =100*DeltaT Mike "dgb82" wrote: Winter Delta T = 82 Deg. F Heating Design Degree Day = 6493 heating degree-days In a work sheet, there are calculations that designate the letters dt or dd as the number 82 or 6483. EX: Btu/h =D9*E9*DT Btu/h 352,469 Or just: when you type =DT in a cell, the number 82 is put into that cell in the work sheet. I would much appreciate it if some one can help me understand how this is done so I can replicate this in the future. Thanks, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
Designate Printer | Excel Discussion (Misc queries) | |||
designate one cell as the variable N to be used for calc... | Excel Worksheet Functions | |||
How do I designate custom locations for Add-in Programs in Excel . | Setting up and Configuration of Excel | |||
Designate a folder as the root of the Browse tree | Excel Programming |