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

Thank you,

Don

"Sandy Mann" wrote:

Define the letters as Names: Insert Name Define and give them the values
=82 & =6493. You can then use them as you are wanting to.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"dgb82" wrote in message
...
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