Welcome Guest.


Excel table: -1-1 to -1-1700 how to ascend

Asked by: Diane 233 views Software December 21, 2018

In the EXCEL form, my data has been entered, from -1-1 to -1-1700, how to sort up

3 Answers

  1. +4Votes  

    Upload sorting is to select the column (row) and click:

    You are not the ascending order that Excel says, it is the custom sequence that Excel said.

    Do you mean this:






    If yes, solve it by adding auxiliary columns (rows).

    Marie- December 21, 2018 |

  2. +8Votes  

    The cell format is set to


    to be in ascending order, Or sorted in descending order.


    Gregory Adams- December 21, 2018 |

  3. +1Votes  

    You can’t directly sort by 1 to 1700 directly!

         Because your format is definitely text format, text sorting and number sorting are not the same


    To reach Sort by last number:

           You can only add one copy column, extract the last number to this auxiliary column, and sort by auxiliary column

    Figure effect:

    B1 input formula:


    This can be sorted by column B auxiliary columns, as shown in descending order

    Johnson- December 21, 2018 |