I have done this before, but cannot remember how.

I am converting lbs to kg and using CONCATENATE to at the kg on the end of
the formula

Example: A1 = 220 lbs B1: =CONCATENATE(A1/2.2 &"kg)

I need to reduce the answer in B1 to two decimal places. I believe I can do
this within the formula, but not sure.

Thanks for you help.

Les