I have a list of about 800 entries counting in the millions, i.e 3.4m 1.2m etc but when I try to list by numerical order it counts down from 9.9 to 0 then from the highest double digit number down to 10.0 rather than just highest down to zero. I think the problem is that the numbers are not formatted as numbers but as text so I need change them to numbers and need to remove the [m] suffix from every entry (I didn’t add it).
Is there a way to do this without going through 800 numbers by hand?