hum... its been realy long since I did anything with Excel.. So I need a
little help making that understandable. To be more specific of what I need
help with:
I got a column with about 200 numbers, they are all 11 digits, now I have to
do something to make the first six digits in each number a date and remove
the last digits. The two first numbers are date, number 3 + 4 are month and 5
+ 6 are year. If that formula does that for all the numbers that would be
nice, but I still need help on how I apply it to the numbers.

Thanks, Oystein.

"Andy" wrote:

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?