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?

 

[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"