convert Julian Date Format to Excel

P

Pablo

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
 
M

Max

Try Data > Text to columns. Select the col of "dates", click Data > Text to
columns. Click Next > Next. In step 3 of the wizard, check "date" under
"Column data format", choose: YMD from the droplist, click Finish. That
should convert it all at one go to real dates recognized by Excel. Format the
col as dates to taste.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change satellite julian date format YYYYDDDHHMMSS to excel date ti 1
convert Julian date to DD/MM/YYYY 7
Convert julian date 14
How to Convert a Julian Date to Calendar Date 2
how to convert from julian date to mm/dd/year 6
Julian dates 3
test to Julian date 10
Julian Date 5

Top