G GrahamS Jun 11, 2008 #1 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 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?
T Tim Otero Jun 11, 2008 #2 GrahamS said: 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? Click to expand... I think this is what you need =A1*B1&" kg"
GrahamS said: 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? Click to expand... I think this is what you need =A1*B1&" kg"
J Jim Cone Jun 11, 2008 #3 ###.## "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?
###.## "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?
