"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)?

Data/ Text to Columns/ Fixed Width
Select output as Date/ YMD
--
David Biddulph