View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dgb82 dgb82 is offline
external usenet poster
 
Posts: 8
Default 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