View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How do I Designating a number with letters?

Select a cell somewhere in your workbook (eg X1 and enter the value 82
in there). Then click on Insert | Name | Define and give that cell the
name DT.

Then in another cell enter the formula:

=DT

and 82 will appear there.

Hope this helps.

Pete

On Aug 6, 5:36*pm, 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