HOW to convert csv decimal numbers correctly into DD-MM-YY?

Hello everybody!
I have a csv file from a device, formatted as follows:

20.02.17.17.56.0.110.071.064
20.02.17.17.56.0.110.071.065
20.02.17.17.56.0.110.071.066

… where the first three comma blocks (20, 02, 17,) correspond to the date format DD, MM, YY.
How can I import this file into the correct date format in Excel (1st cell would show up then 17-02-20)?

As a solution I've already got the answer
=DATWERT(C1&"."&B1&"."&A1)

but putting this string as a function, I haven't been successful yet.

Many thanks you for tips and solutions

chris

Re. the comma/dots.... this is just a language thing; it doesn't help, but in German, "eins-komma-zwei" means "one point two". Anyway...

The problem is that you're feeding the DATEVALUE() a string with dots... Excel doesn't like it. If you use "/" instead it should work:

Formula:

Please Login or Register  to view this content.

Personally, I wouldn't trust Excel's guessing skills.

You might be better using DATE(YEAR,MONTH,DAY) instead - to avoid ambiguity. It would look like this:

Formula:

Please Login or Register  to view this content.

(or whatever that function is called in German.

HTH
Tim


EDIT: it's "DATUM()"

Originally Posted by porucha vevrku

There are no "comma" blocks here, but "dot/point" blocks ...

Sorry, for the unrealized COPY ERROR - but the original file is with comma