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. ...
Taii36 But does it work now?
Sort of. Some values worked, but it created blanks for others
I didn't use Text to Columns, the conversion is done by a formula.
If you get exponential notation, you may need to widen the column, and perhaps apply a custom number format.
Thank you. I was wondering if you covert the text to columns or skipped this step. I tried copying the formula but ended with an exponential answer like 1.1E+08
See the attached version.
Could you send a file that demonstrates where it fails?