PC Review


Reply
Thread Tools Rate Thread

How do I Designate a number with letters?

 
 
dgb82
Guest
Posts: n/a
 
      6th Aug 2008
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

 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      6th Aug 2008
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
>

 
Reply With Quote
 
Mike H
Guest
Posts: n/a
 
      6th Aug 2008
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
> >

 
Reply With Quote
 
dgb82
Guest
Posts: n/a
 
      6th Aug 2008
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
> > >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
IS THIS POSSIBLE? NUMBER OF LETTERS IN A CELL??? HERNAN Microsoft Excel Misc 2 29th Apr 2008 02:57 PM
number to letters =?Utf-8?B?RWQ=?= Microsoft Excel Misc 3 10th Jun 2006 05:11 PM
create a unique reference number of letters and sequential number =?Utf-8?B?amFuZWFzaGFycA==?= Microsoft Access Getting Started 1 13th Apr 2006 06:43 PM
how i write a number on a column A and see that number on letters. =?Utf-8?B?TWF1cmljaW8=?= Microsoft Excel Worksheet Functions 2 12th Mar 2006 09:29 PM
'Designate Your Own Drive Letters' rz Windows XP Accessibility 0 22nd Aug 2003 08:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:58 AM.