dates format when exported to excel

Roozbeh,
All data exported to excel is a text format. To change the format highlight all date and press Ctrl+h (replace command). Enter ’ on find what and leave the replace with empty then click replace all. Format will change automatically to date. Highlight again and press Ctrl+1 (format cell command) and select the date format you want.

Rodel,

thanks for your reply. in fact this is what I do every time I export to excel.

do you have any idea why some times this happens with export to excel. in some cases i noticed that the time is not exported. especially i noticed that for a project with resource dependant activities which there were no relationship between activities and activites were scheduled based on their asignments.

in addition, is there any way to prevent that. some times when I need to do frequent exports to excel, it would save time and effort for each time changing the format in excel.

Roozbeh,
By default P6 use 12:00 AM time and all activities having default 12:00AM will not export time format but once you change the 12:00AM default time and assigned a regular time like 08:00 AM for start and 05:00PM for end of day then it will include time format. There is no way you can prevent exporting date format only once you assigned the correct time because that’s P6 calculating base.

Rodel,

where in P6 we can change time to 12:00 AM

regards

Roozbeh,
Edit-> Users Preferences-> Date tab-> Time-> 12 hour format and select show minute. Then you can change time for all dates.

Rodel,

If the activity calendar is for example 8:00 AM to 5:00 PM then time can not be set to 12:00 AM, can it.

So I guess I have to live with it. Is that correct.

Moreover, normally when exported to excel, I used VALUE formula to change the text format to date. I tried to use ctr+h and replace ’ with blank, but excel 2003 seems does not recognizes this character ’ and says couldn’t find any to replace.

Regards,
Rouzbeh

Rouzbeh,
Once you assigned time to activity it still can adjust to 12:00Am but you schedule would have wrong output therefore yes you have to live with it.

I’m also using MS Office 2003 and replace function is working fine. You better check the default font as it has different equivalent on key stroke.