Jan 23 2022 06:39 AM
Results from a query in Date column won't change format unless I physically go into the cell and press enter. So, other than pressing F2&Enter, how can I get the format to take on all cells in column? I've tried many date formats on entire row and it's only working on some of the cells. All are using the dash (-) between dd-mm-yyyy
Jan 23 2022 08:48 AM
It looks like we speak not about formatting, but about converting texts which looks like dates in to dates (which are actually numbers in Excel).
You may select column with such texts, Data -> Text to Columns -> on third step of the wizard select Date type and DMY as source format ( or which one you have).
Jan 23 2022 01:28 PM
Jan 24 2022 12:49 AM
Good to know you sorted this out. As a comment, most probably you don't need to split on columns, all could be done within one column.