LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert Julian Date Format to Excel Pablo Excel Discussion (Misc queries) 2 January 14th 08 08:40 PM
Change satellite julian date format YYYYDDDHHMMSS to excel date ti putley Excel Discussion (Misc queries) 1 January 11th 08 06:12 PM
how to convert from julian date to mm/dd/year robin watersong Excel Discussion (Misc queries) 6 September 9th 07 04:18 AM
Convert a julian gregorian date code into a regular date Robert Excel Worksheet Functions 3 June 13th 06 07:03 PM
convert Julian date Doug Excel Worksheet Functions 3 May 5th 05 07:30 PM


All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"