Hi!

Try this:

Select the range in question.
Goto DataText to Columns
Click Next, Next
Select Date
From the drop down select YMD
Click Finish

Biff

"DJ" wrote in message
...
I have been given an Excel spreadsheet with numbers in 8-digit text format.
For example, 20020812 would be August 12, 2002. How do I convert these to
some sort of date field that will allow me to perform calculations (count
days from one date to the next)?