This kept returning a value of 00.00kg. However, your other option worked.
I could not figure out how to set the custom format up.

Thanks,
Les

"Mike H" wrote:

Try

=CONCATENATE(TEXT(A1/2.2,"00.00"))&"Kg"

Mike


"WLMPilot" wrote:

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