On 2/23/2020 2:42 PM, Robert Großkopf wrote:
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
You and Brian are correct.
Thanks for the help,
--bill
--
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
