One way:

Select a column of dates to be converted. Choose Data/Text to Columns.
Click Next, Next, then select YMD from the Date dropdown. Click finish.

Repeat for any other columns of dates.

In article .com,
Heine wrote:

hello everybody

I have thousands of rows looking like this:

20060505
20070302
20050708

etc.

How can I change these to date formats so I can calculate the number
of days between these dates and another row of dates?

Any ideas?

regards
Heine