'Excel string to number conversion, while getting rid of the M for a whole column
I am working with data that was entered as a string, $105M, instead of a numerica value, 105,000,000.00
How do I convert this? I have been Googling and have looked up several times. It's referencing athlete salaries, and thus, they're all in the millions. To simplify, they just put M instead of the whole, much larger, number. I understand why, but now I can't do the sum of the columns, and I can't do much with it in my Tableau visuals. Any advice or ideas? I want to convert both the Salaries and Endorsement columns. I will attache a picture. Thanks.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|