Hi William, > I have a spreadsheet downloaded from my bank. I changed the first col > to format date MM/DD/YYYY but when I sort the sheet it is still sorting > the first col as if it were text, starting with 01/01/2020 and ending > with 12/31/2019 (in ascending order).
Seems it is inserted as text. Mark the whole column. Go to Data > Text to Columns Mark the column header of "Fields" Change the listbox to Date (MDY) Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
