ExcelBanter - How do I sort in strict numerical order? i.e. 105 before 1049

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I sort in strict numerical order? i.e. 105 before 1049 (https://www.excelbanter.com/excel-discussion-misc-queries/93956-how-do-i-sort-strict-numerical-order-i-e-105-before-1049-a.html)

mgr

How do I sort in strict numerical order? i.e. 105 before 1049

Hi

Excel will automatically sort in that order if the values are numeric.

Andy.

"mgr" wrote in message
...

All times are GMT +1. The time now is 01:52 PM.