View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pablo pablo is offline
external usenet poster
 
Posts: 76
Default 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