I got a list where Column A is 198 and column B is K, meaning 198K, and this is about a 1600 item list. Ive been asked to convert column A to 198000, etc for 1600 different numbers.
Is there a way to do this with formatting or a formula? Also, some of them are 107.1 meanling 107100.

If someone could help w/ this I'd appreciate it. Thanks