Date formats while exporting from P6

Member for

22 years 9 months

Member for 22 years 10 months

Submitted by Ronald Winter on Tue, 2011-08-23 15:32

Permalink

Jomon, The problem with

Jomon,

The problem with date formats in your spreadsheet has nothing to do with P6. P6 exports a Julian date number. Excel interprets that number and if the cell is formatted for dates, then will display the date in the default format. Go to Format Cells, Number Tab, Category = Dates , and select the desired date type. Good luck!

Member for

14 years 2 months

Member for 14 years 2 months

Submitted by josejomonm on Tue, 2011-08-23 14:47

Permalink

Thanks for your comment. The

Thanks for your comment. The user preference setting is same (Day,Month,Year) for both of us. But still the excel sheet is opening in different format. Also i request him to log on to P6 from my laptop then he also getting the format similar to me. Now i dont know any setting in my PC is the one controlling it.

Member for

14 years 2 months

Member for 14 years 2 months

Submitted by josejomonm on Tue, 2011-08-23 14:47

Permalink

Thanks for your comment. The

Thanks for your comment. The user preference setting is same (Day,Month,Year) for both of us. But still the excel sheet is opening in different format. Also i request him to log on to P6 from my laptop then he also getting the format similar to me. Now i dont know any setting in my PC is the one controlling it.

Member for

15 years 9 months

Member for 15 years 9 months

Submitted by kumar s on Tue, 2011-08-23 14:30

Permalink

Dear Jose, you have to keep

Dear Jose,

you have to keep the same format in the edit preferances then you will get the same format i think

cheers