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

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