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?
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?