=DATE(LEFT(A1,4),1,MID(A1,5,3))+TIME(MID(A1,8,2),M ID(A1,10,2),RIGHT(A1,2))

and format the cell as Custom mm/dd/yyyy hh:mm:ss

For example if A1 contains 1999300020202
the formula returns: 10/27/1999 02:02:02

--
Gary''s Student - gsnu200765


"putley" wrote:

In need an excel function to convert the julian date format commonly used for
satellites, YYYYDDDHHMMSS (DDD is julian day of year) to Excel date time
format.