Proper column types for dates in excel

[spapas]

Hello friends, when exporting dates in excel, they are exported in text columns. This leads to problems for my users when trying to sort these date columns. For example 23/12/2024 and 22/12/2023 will not be sorted properly !

I'd like to discuss possible solutions to this; I've tried various things but the only two viable things I've found are:

• Change the value of the column to YYYY-MM-DD so it sorts fine even as text
• Tell the users to parse the dates using text to columns

Can you recommend anything else or maybe a way that this could be fixed by a patch in django-tables2 ?