Custom Number format showing units.
 

I want to do a calculation multiplying 2 cells with the result to show in a
3rd cell as: ###.## kg. How do I get the kg to appear?
--
Cheers, GS

Custom Number format showing units.
 

GrahamS wrote:
I want to do a calculation multiplying 2 cells with the result to show in a
3rd cell as: ###.## kg. How do I get the kg to appear?


I think this is what you need

=A1*B1&" kg"

Custom Number format showing units.
 

###.## "kg"
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"GrahamS"
wrote in message
I want to do a calculation multiplying 2 cells with the result to show in a
3rd cell as: ###.## kg. How do I get the kg to appear?
--
Cheers, GS

Custom Number format showing units.
 

Format, Cells, Custom and in box type in:
#,##0 "kg"

"GrahamS" wrote:

I want to do a calculation multiplying 2 cells with the result to show in a
3rd cell as: ###.## kg. How do I get the kg to appear?
--
Cheers, GS