Forum Discussion
Converting data into millions
Hi, I am working with a dataset where the wages are recorded in £M or £K. I was wondering how I would convert all the numbers into £M. For example, if the account was £8.5M. It would remain at 8.5M. ...
I tried both approaches but still a bit confused. I can send a small example through private message
your previous example had £ (pound sterling), the new one has € (euro).
The attached version does not depend on the currency symbol. Converted Wage #1 shows the text values converted to numbers. Converted Wage #2 has the exact same formula, but a custom number format.
- Because i did this with the original data set following the approach by Quraduple but the boxes remained empty
Taii36 But does it work now?
- Sort of. Some values worked, but it created blanks for others