@JOSE COSTA - Ooooo
Have You copied those someway from somewhere?
It will be challenge even for Excel to know which part of date is month or day!
Row 55 > 02/04/2016 23:50:00
Row 56 > 02/05/2016 00:00:00 ... april or february or may?
Excel cannot know! I think that this is february.
Row 1207 02/12/2016 23:50:00 ... why change format, feb or dec?
Row 1208 13/02/16 00:00:00 ... this have to be february!
if 'clicks' in front of those 'short days' and press <enter> => dd/mm/yyyy
Row 3639 29/02/16 23:59:00 ... end of february
Row 3640 03/01/2016 00:00:00 ... hmm mar or jan? why change format?
Even dates have to be always in same format!
Of course, I can modify all one-by-one ... how do You think?
Or ...
If those are really 4th feb 2016 15:00:00 to 9th mar 2016 21:30:00 with 10 minute steps. It would be easier to do.
Oh! NO! C-Column is also save like text!
Please, dates should be dates and numbers should be numbers!
I tried I tried ...
and then I noticed that You didn't use the last version of this case!
Check 'Memo 25.02.16 22h.xlsb' -output! There is 'P-section' too!
(This DO NOT MATCH with the newest data)
And I noticed that numbers are not numbers! Columns are not match!
Which column values should be in which column?
Please, layouts have to be always same!
I used hours to do something ... which would avoid to use valid data and the newest version ...
what to do?
Have You copied those someway from somewhere?
It will be challenge even for Excel to know which part of date is month or day!
Row 55 > 02/04/2016 23:50:00
Row 56 > 02/05/2016 00:00:00 ... april or february or may?
Excel cannot know! I think that this is february.
Row 1207 02/12/2016 23:50:00 ... why change format, feb or dec?
Row 1208 13/02/16 00:00:00 ... this have to be february!
if 'clicks' in front of those 'short days' and press <enter> => dd/mm/yyyy
Row 3639 29/02/16 23:59:00 ... end of february
Row 3640 03/01/2016 00:00:00 ... hmm mar or jan? why change format?
Even dates have to be always in same format!
Of course, I can modify all one-by-one ... how do You think?
Or ...
If those are really 4th feb 2016 15:00:00 to 9th mar 2016 21:30:00 with 10 minute steps. It would be easier to do.
Oh! NO! C-Column is also save like text!
Please, dates should be dates and numbers should be numbers!
I tried I tried ...
and then I noticed that You didn't use the last version of this case!
Check 'Memo 25.02.16 22h.xlsb' -output! There is 'P-section' too!
(This DO NOT MATCH with the newest data)
And I noticed that numbers are not numbers! Columns are not match!
Which column values should be in which column?
Please, layouts have to be always same!
I used hours to do something ... which would avoid to use valid data and the newest version ...
what to do?