One more method without the formulas to deal with.

DataText to ColumnsNextNextColumn data formatDate YMD and Finish.


Gord Dibben MS Excel MVP

On Tue, 22 May 2007 19:01:02 -0700, JWNJ wrote:

I have been given an Excel file with that contains the installation date for
10,000 items. I need to determine the number of days/years these items have
been in-service. I know the appropriate formula to determine the number of
days between two dates; my problem is the installation date is formatted as
yyyymmdd. So, for example, today appears as 20070521. How can I convert
this is appear as 5/21/07, or some legitimate date format. Thanks in advance
for your help.