Custom Number format showing units.

[GrahamS]

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?

 

[Tim Otero]

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"

 

[Jim Cone]

###.## "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?

 

[Jim May]

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