Import/Export Dates with Excel 1

[Gabespar]

I can copy cells with tasks and dates from Excel into Project2010 with no problems.

Yet, when I copy the tasks and dates from Project back to Excel, the Date cells are not recognized as dates in excel, nor can they be reformatted as dates.

Project changes the mm/dd/yy format to Fri mm/dd/yy.

How can I get an excel recognized date format from Project?

Thanks,
Gabe

 

[PDQBach]

In P2010

Open the file
Click on File > Options
In the new display click on "General"
On the right locate "Date format" and select the second one ("1/28/09") Note: This is a global setting and all other projects will open with their dates in this format.
Click on OK

Copy&paste from P2010 date fields to Excel.

In P2003:
click on Tools > Options > View-Tab
Look for "Date format" and select the second one ("1/28/02")
Click on OK

 

[JulieInMaine]

Are you importing or copying and pasting? I cannot re-create what you report using Project 2010 and Excel 2010. I can leave the date/time to showing Day of the week, month, day and year.

Do you have SP-1 installed to project and excel?

Julie

 

[PDQBach]

@Julie ... I'm pretty sure it has to do with the date formats. If he's using (as I do) "ddd mmm d, yy" ("Fri Apr 6, 12") then it gets copy-pasted as a text field; if he uses "mm/dd/yy" (4/6/12) then it gets copy-pasted as a date field -- there may be other formats that copy-paste as dates, I just chose the first that I was pretty sure would work.

 

[JulieInMaine]

Ah, I see. I don't use that format usually so I've not seen this issue.

Julie

 

[Gabespar]

@PDQBach - Thank you!
Gabe

 

[SkipVought]

I'd suggest you get a better understanding of Excel Dates

faq68-5827



Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]