Revenue Correction

Hi All,

I have the revenue in Column B. As I had mentioned in Column C is required.

1. If column B has only number. It is be as it its.
2. If column B has revenue with K example: 10989K This K should be removed and it has to be multiplied by 1000.
3. If column B has revenue with K example: 3125.31M This M should be removed and it has to be multiplied by 1000000
3. If column B has revenue with K example: 6545.79B This B should be removed and it has to be multiplied by 1000000000

Please find the attachment