Beginners Question

G

GordyB

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.
 
R

Roger Govier

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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
J

Jim Thomlinson

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
 
G

Gord Dibben

8.5 in A1

32 in A2

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


Gord Dibben MS Excel MVP
 
Top