'Converting differents units to numbers
I'm trying to convert a column of money amount to numeric values. But in the same variable I have differents units( 9000, 10.1k, 11k ) .How Can I put the "k" with the proper amount of zeros?
I was trying to change the "k" for "000" but this only works for 13k or 14k not amounts like 13.1 k
Solution 1:[1]
The "k" at the end of numbers stands for multiplication by 1000. So, instead of appending three 0s, you could simply remove the "k" and multiply the number by 1000.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Sannat Bhasin |