That is not real Julian dates, for your problem you can go to

http://www.cpearson.com/excel/jdates.htm


real Julian dates is the number of days that have passed since noon on
January 1st, 4713 B.C.

Regards,

Peo Sjoblom






"Jessica" wrote:

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