Forum Discussion
Yok33
Nov 29, 2022Copper Contributor
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 ...
Yok33
Nov 29, 2022Copper Contributor
Thank you Patrick2788. Although I am not faamiliar with data filters. Is that some that is in Excel? Or something I have to download?
Patrick2788
Nov 29, 2022Silver Contributor
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