Hi

You could do it with a formula - in one go:
=DATE(MID(A2,5,2),MID(A2,3,2),LEFT(A2,2))
This works for me (in English format).

Andy.

"Oystein" wrote in message
...
I got a row that contains numbers with 11 digits, I need to delete or move
out the last five so I can make the first six a date.
Any good ideas?