Select a blank cell next to your pounds data, and type this formula =CONVERT(A2,"lbm","kg") into it, and press Enter key, then drag the autofill handle down to the range cells you need. To convert kg to pounds, please use this formula =CONVERT(A2, "kg","lbm").