how to format this date type?

Originally Posted by NickyC

hi
try this formula

=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2))

thanks, but no, something is not right, i have copied that formula and this is what i got
Screenshot - 20.06.2017 , 01_23_20.png
the date appears as 20.06.2017 ... this is not what I need, like i mentioned above, id need the date to be formatted as:

YYYY MM DD HH MM SS


to avoid missunderstanding, can you upload the .xls with the formula so that the date comes already formatted?

many thanks!