How do I Designate a number with letters?

  • Thread starter Thread starter dgb82
  • Start date Start date
D

dgb82

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
 
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
 
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
 
Sorry about that Mike.

Also, I was woundering if you work for microsoft?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I Designating a number with letters? 8
How do find text with sumproduct if possible 11
sum letters with values and numbers 2
CountIf on not number values. How can I solve? 4
How can I change column designation from number to letters? 3
How do I return a number for a formatted cell value? 2
Counting how many numbers and letters appear in a particular row 7
How do I seperate a alphabet and number in a cell-in Excel 2

Back
Top