5 iulie 2012 12:53
PS 2010 ,The Date Order in the Period Start Date and Period End Date is inconsistent. Sometimes DD/MM/YYYY, sometimes MM/DD/YYYY.i have Users from different regions.
9 iulie 2012 06:59
If the column is formatted using a * denoted date format, it will use the user's local regional format for the date. If you want it fixed across all locales, do not use a * date format in Excel.
10 iulie 2012 06:45
First i change the regional setting for the user who is opening the project it solve the problem bot not entirely.
after your suggestion i made changes in the excel and now it is working perfectly.