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. ...
=IF(RIGHT(C7,1)="M",C7,"£"&MID(C7,2,LEN(C7)-2)/1000&"M")You can try this formula for the data layout of the example.
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.
