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. ...
Hi, sorry what would this lead to? I am just a beginner so not exactly sure what the outcome of this would be
See the attached sample workbook. It demonstrates OliverScheurich 's approach and and alternative.
- Thank you. I'll check it out
- 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.