Sorting cells that are both integers and decimal numbers

  • Hello,


    I am trying to sort a column in excel from A to Z. There are cells that contain the following:


    - whole numbers only e.g. 24, 6 etc.
    - whole numbers and text string e.g. 24 years etc.
    - decimal numbers e.g. 7.23, 27.46 etc.
    - decimal numbers and text string e.g. 7.23 years etc.


    I am encountering problems whereby excel 'reads' a number like 7.23 as 723. As a result, it is not sorting properly by putting in the appropriate sequence (e.g. 7, 7.23, 7.5, 8 etc.)


    As there is also text in the cells I am unable to simply switch the cell format to 'number'.


    Is there a way to make sure excel recognizes the decimal numbers appropriately?


    Any assistance would be greatly appreciated.


    Thank you

  • Re: Sorting cells that are both integers and decimal numbers


    have you tried sort with option "Sort Anything that looks like a number, as number? if yes then only way around this to have a help column which convert all to number and then sort on that column.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!