View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How do I Designating a number with letters?

See "Define Name". Basically the cell containing 82 has been named dt
and the cell containing 6493 has been named dd.

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