Forum Discussion
Sorting Microsoft Excel
Why is it that when I have a spreadsheet that has about five columns (Date, Amount, Customer, Ref #, Invoice # and Notes) and I try to sort according to date, it does not sort correctly. Even if I ...
Thank you Patrick2788. Although I am not faamiliar with data filters. Is that some that is in Excel? Or something I have to download?
Click any place in your data and go to the Data menu and select Filter.
When you click the drop filter for the dates column, Excel will consolidate dates.
If the dates are text, you'll get this:
If you have legitimate dates, you'll get this:
If needed, this article provides a few ways to convert 'numbers stored as text' to numbers.
Convert numbers stored as text to numbers - Microsoft Support