Hi Everyone,
I do a lot of sports standings sheets. When using LibreOffice Calc, if I have ten rows to indicate position or place 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. and sort them, tenth always comes between first and second. I have to change tenth to 99., then sort, then change it back to 10. Is there a fix for this that someone could point me towards? I like using Calc over similar programs, but this is one fault I have with it.
Thank you in advance!
Suspect the numbers are being considered by Calc as text and therefore sorted by alphabetic order instead of numeric.
If you have locale where “,” is the decimal separator, then when you enter “1.” this will be treated as text and not a number. Solution would be to enter “1”, “2” etc instead of “1.”, “2.” etc.
Other possible cause is if data is imported from csv files with incorrect choice of format for the column of data.
Use “View”, “Value Highlighting” to show numeric data in blue and text in black to confirm your data is entered correctly.