Forum Discussion

senglory's avatar
senglory
Copper Contributor
Apr 30, 2023

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

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?

Resources