problem sorting

users
#1

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).

I can't figure out what is wrong.
thoughts/suggestions

Thank in advance,
bill

#2

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

#3

You and Brian are correct.
Thanks for the help,
--bill