I’m trying to sort the whole table by the column L. I’ve chosen descending order, however it picks 9.89 as a higher value than 79.06; 6.93 as a higher value than 59.26 and so on. I’ve been suggested to use the ‘number format’ (button I marked on screenshot), but this doesn’t change anything.
What do I need to do in order for this sort to be correct?
Below screenshot with marked difficulty.
https://gyazo.com/c7046bf6133859e3fe28b5fdbde345b6
Thanks!
Use view, value highlighting. Numbers show blue, text in black.
Look for leading or trailing spaces and remove them.
Depending on your language settings you might need , instead of . For decimal point.
Select a cell and check if it begins with ’ in the formula entry box, as this forces data as text.
After changing cell format from text to number, any existing data will have ’ added which forces the content to still be treated as text until you remove '.
Looks as if data was imported from a csv/txt file, on the import window, selecting for every column their type or using i.e. UK English as import language could solve the issue with decimal point so numbers are imported as numbers not as text.
Thank you, changing the language solved the issue.