edit: sorry, but I typed the title incorrect. It wont allow me to edit that either. It should say: " d:h:m:s "
numbers that I have formatted so they appear this way:
![Capture405.JPG Capture405.JPG](https://www.mrexcel.com/board/data/attachments/113/113308-cdec98e02e3e24224d3f7d21bf4135b7.jpg)
like this:
![Capture407.JPG Capture407.JPG](https://www.mrexcel.com/board/data/attachments/113/113309-7cbece4100cbb3f19e31146c4c225c97.jpg)
do not sort in the correct order when I use:
And it doesnt make any difference how I format the cells, custom (I tried many different ways), general, time, date, text... it always comes out the same.
![Capture408.JPG Capture408.JPG](https://www.mrexcel.com/board/data/attachments/113/113310-9c9f9a7b3e123cabfb464269df9729e5.jpg)
Any suggestions for how can I change the format or number sequence in order to make it sort correctly?
When sorted from left-to-right, it looks like this: (all is in the correct order until the cells that are circled in red)
![Capture403.JPG Capture403.JPG](https://www.mrexcel.com/board/data/attachments/113/113311-623df950acf2d1f7380165d1ffb98bfd.jpg)
numbers that I have formatted so they appear this way:
![Capture405.JPG Capture405.JPG](https://www.mrexcel.com/board/data/attachments/113/113308-cdec98e02e3e24224d3f7d21bf4135b7.jpg)
like this:
![Capture407.JPG Capture407.JPG](https://www.mrexcel.com/board/data/attachments/113/113309-7cbece4100cbb3f19e31146c4c225c97.jpg)
do not sort in the correct order when I use:
VBA Code:
ActiveWorkbook.Worksheets("NOT-ACTIVE").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("NOT-ACTIVE").Sort.SortFields.Add Key:=Range("N15", Range("N15").End(xlToRight)), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
And it doesnt make any difference how I format the cells, custom (I tried many different ways), general, time, date, text... it always comes out the same.
![Capture408.JPG Capture408.JPG](https://www.mrexcel.com/board/data/attachments/113/113310-9c9f9a7b3e123cabfb464269df9729e5.jpg)
Any suggestions for how can I change the format or number sequence in order to make it sort correctly?
When sorted from left-to-right, it looks like this: (all is in the correct order until the cells that are circled in red)
![Capture403.JPG Capture403.JPG](https://www.mrexcel.com/board/data/attachments/113/113311-623df950acf2d1f7380165d1ffb98bfd.jpg)