Beginners Question

  • Thread starter Thread starter GordyB
  • Start date Start date
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.
 
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
 
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
 
8.5 in A1

32 in A2

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


Gord Dibben MS Excel MVP
 
Back
Top