Julian day numbers

[Guest]

I have a series of files containing 1 month's worth of hourly measurements.
The date for each measurement is in Julian day format (30 = Jan. 30th, 145 =
May 23rd, etc.). When I change the cell format of these numbers to dates, it
automatically attaches the default year of 1900, which we all know excel
incorrectly lists as a leap year. Is there any way I can drag and drop the
correct year of the data into the cells? If not is there a way I can change
the default year for the worksheet?

Zach

 

[Peo Sjoblom]

Put 12/31/06 in a cell, copy it, select your numbers and do edit>paste
special and select add. (note that 145 is May 25th)