First off, the formula you posted is not right.
If you are multiplying the value in cell D2 by 2.2 the formula is =D2*2.2
Also Excel has built-in conversion formulas which are more accurate.
Here is the kilogram to pounds conversion:
Then just drag the formula down the column.
If the first formula was in cell E2,
drag it down to E3 and you get
Look up Help for the Convert() function for more conversions. Note that prefixes such as "k" for kilo are shown in a separate group in the help file.