problem sorting

classic Classic list List threaded Threaded
3 messages Options
williamdrescher williamdrescher
Reply | Threaded
Open this post in threaded view
|

problem sorting

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


--
To unsubscribe e-mail to: [hidden email]
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
Robert Großkopf Robert Großkopf
Reply | Threaded
Open this post in threaded view
|

Re: problem sorting

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: [hidden email]
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
williamdrescher williamdrescher
Reply | Threaded
Open this post in threaded view
|

Re: problem sorting

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: [hidden email]
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