I know how to add two cells but I would like the cells to have a title within 
the cell.  Something like 8.5 Hrs, or 32 steaks.  Something like that. 
-- 
Thank you in Advance

Hi

Format>Cells>Number>Custom>
#.0 "Hrs"
or General "Steaks

The part before the text can be formatted in any of the standard number 
formats.
It will appear as 32 Steaks, but all that will be held in the cell is 32, 
which can then be used in further calculations if required.
-- 
Regards
Roger Govier

"GordyB" <GordyB@discussions.microsoft.com> wrote in message 
news:3FAC50B8-59F5-43E6-BDFF-B79F13627E18@microsoft.com...
> I know how to add two cells but I would like the cells to have a title 
> within
> the cell.  Something like 8.5 Hrs, or 32 steaks.  Something like that.
> -- 
> Thank you in Advance
>
> __________ Information from ESET Smart Security, version of virus 
> signature database 4825 (20100201) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
> 

__________ Information from ESET Smart Security, version of virus signature database 4825 (20100201) __________

The message was checked by ESET Smart Security.

http://www.eset.com

In the same way you can format a number to have a $ sign or % sign you can 
create a custom format with whatever characters you want...

Format | Cells... | Number tab -> Custom
where it says Type:
0.0 "Hrs"
Ok
-- 
HTH...

Jim Thomlinson


"GordyB" wrote:

> I know how to add two cells but I would like the cells to have a title within 
> the cell.  Something like 8.5 Hrs, or 32 steaks.  Something like that. 
> -- 
> Thank you in Advance

8.5 in A1

32 in A2

In A3 enter   ="I ate " & A2 & " steaks in " & A1 & " hrs"


Gord Dibben  MS Excel MVP

On Mon, 1 Feb 2010 14:20:01 -0800, GordyB <GordyB@discussions.microsoft.com>
wrote:

>I know how to add two cells but I would like the cells to have a title within 
>the cell.  Something like 8.5 Hrs, or 32 steaks.  Something like that.