Apr 30 2023 02:58 PM
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?
May 01 2023 12:26 PM
What is the short date format on your computer? dd-MM-yyyy, or dd/MM/yyyy, or MM/dd/yyyy, or ...?