Are there other options besides K in column B? Any M's to indicate million? Any blanks to indicate that the number in column A should be left as is? Or does every entry in column A need to be multiplied by 1000? If everything needs to be multiplied by 1000 without exception, then it should be pretty easy to put the formula =A1*1000 in C1 an copy down.