Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert Julian Date Format to Excel | Excel Discussion (Misc queries) | |||
convert Julian Date Format to Excel | Excel Discussion (Misc queries) | |||
Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
convert Julian date | Excel Worksheet Functions |