| 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 | |||
Linear Mode
