Forum Discussion
Irregular Sorting in Excel
The file is stored in OneDrive / Sharepoint.
Okay, let start from scratch.
- is another sorting order on your laptop for sorting numbers or texts or months or all of above?
- sorting could depend on locale (regional settings), are they the same for the laptop and another computer on which you tested?
- if copy the file from OneDrive to local folder (not synced with OneDrive) will you have the same sorting order as for the OneDrive file?
- what are regional settings for OneDrive?
But first question what is sorting incorrectly. E.g. 5,9,1 is sorted as 9,5,1 or doesn't sorted at all or what.
- Hi. Does Regional Sertings really effect sorting of TEXT? My Data instead of sorting from 1-9 and then A-Z is sorting randomly (only on my computer). The order is not making sense. And as I mentioned if I use my iPad to sort the same data, it sorts in correct order i.e. 1-9 and A-Z.
Other files on my Laptop are sorting in correct order, so dont think it's a Regional Sorting Issue.
Also moved the file from OneDrive to my local drive, but the sorting is still irregular.So, do I understand correctly that's only for one concrete workbook, and perhaps only for one worksheet in this workbook? And if you sort exactly the same file (not copy/pasted data) on iPad it sorts it in a right way?
- Correct.