I have an issue regarding sorting from smallest number (value) to biggest in my Excel 2021.
Sample of my data:
1070/105
1070/11
1070/3
1070/205
1070/206
1070/207
1070/120
1070/50
1070/2
1070/4
I think the problem lies in the slash symbol (/) as Excel does not read it correctly. I tired to change all slashes into decimal separators, to change the data to a decimal number. Then I have sorted them from smallest to biggest and then again changed the symbol back to slash. That did not help.
Is there an easy solution to it, or do I need to use some kind of custom VBA to solve that?
Bookmarks