=DATE(2000+LEFT(A1),1,RIGHT(A1,3)+0)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a long list of Julian dates that are formatted as
follows:
3300
1296
0346

The first number is the year, i.e. 2003, 2001, 2000.
The next three numbers are the numeric equivalent of
where that date falls
in the year, i.e. 300=Oct 27, 296=Oct 23, and 346=Dec 12.

Excel talks about how to convert to a Julian date, but I
have not found how
to go from a Julian date to a regular date that I am
used to seeing.

Many thanks,

Jessica Nelson
.