Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel 2021 - how to set format for date&time as 'dd.MM.yyyy HH:mm'?

Copper Contributor

Hi,

I've got an Excel workbook with column containing text which represents date&time as  the specified format, i.e. 'dd.MM.yyyy HH:mm'. But this column is not recognized as a date&time, so I have to specify its format explicitly to be able to do sorting lines per this date correspondingly. When I try to open dialogbox 'Format cells', it gives me no opportunity to specify desired date&time format for the column. How could I assign necessary format for tis column in this case?

1 Reply

@senglory 

What is the short date format on your computer? dd-MM-yyyy, or dd/MM/yyyy, or MM/dd/yyyy, or ...?