convert julian date format to excel
 

Dear Reader,

I have a data download that gives back a date field in Julian format. It's
in the following format:

Create TS
2007/12/13 19:44:10

How can I convert this date format into a usable Date format? I can live
with just the 12/13/2007 date format, but would like date + time.

Thanks,

Pablo

convert julian date format to excel
 

You have answers elsewhere - please do not multi-post.

Pete

On Jan 14, 9:04*pm, Pablo wrote:
Dear Reader,

I have a data download that gives back a date field in Julian format. * It's
in the following format:

Create TS
2007/12/13 19:44:10

How can I convert this date format into a usable Date format? *I can live
with just the 12/13/2007 date format, but would like date + time.

Thanks,

Pablo