Julian day numbers
 

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

Julian day numbers
 

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


--
Regards,

Peo Sjoblom


"ZachB" wrote in message
...
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