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. ...
They are in the format of £11M or £8K. Not in actual numbers so I don't if what you have suggested would work
Ok, Use find and replace with values, CTRL + H
For getting convert to 1M = 1000000
In find value what type m
replace with 000000
Click replace all, M is replaced with 000000
same way for K 1K=1000
In find value what type k
replace with 000
1k will become 1000
make sure that based on text just give decimal value
For getting convert to 1M = 1000000
In find value what type m
replace with 000000
Click replace all, M is replaced with 000000
same way for K 1K=1000
In find value what type k
replace with 000
1k will become 1000
make sure that based on text just give decimal value