I have a list of files in Windows Explorer sorted ascending by name
3a.txt
6a.txt
10a.txt
In Excel I have the names of these files in a column, I sort them A-Z and except them to be the same as the order of the files in Explorer, however this is not the case:
Sheet1: SORTED A-Z
10a.txt
3a.txt
6a.txt
I do not mind whichever sorting is used however I need the sorting to be consistent across both programs. Is there an easy way to achieve this?
dir /o:n
in cmd orls
in powershell to get the files in lexicographic order which is similar to Excel, no need to change the sorting order in Explorer