This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am a UK-based User who has recently migrated to Windows 7 and Office/Project 2010. My computer is configured to the UK but when I do a Save As in Project 2010 and output to an Excel File the dates come out in US Format (mm/dd/yyyy hh:mm). I want them output in UK Format; i.e. DD/MM. What do I need to change to get this to happen? Preview shows them in UK Format.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Sorry, I was less than clear. The errors I have seen posted are when grouping a pivot table in Excel -- not applying grouping in Project.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 92%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Lyric,
When you say you checked your settings I assume you checked both the system setting and the Excel format setting, right?
Julie's response mentioned an issue with grouping so try this. Create a simple Project file, say one to two lines. Make the duration a few days and don't assign any resources. Now, export to Excel 2010 by creating a new export map. Does it work?
John
Pardon me for bumping in -- but I don't think it's a Project issue -- more likely an Excel issue if saving as Excel 2003 works as expected. I've seen some posts regarding issues with Pivot Table issues in Excel 2010 and the locale settings getting lost with grouping.
Julie
John,
I checked as you suggested and it is definitely UK.
I have rechecked everything else and consulted colleagues. I am definitely configured for the UK.
Further digging has discovered that if I Save As in Excel 2003 it works fine, it is only when I go with the straight Excel Option.
Furthermore I now know I'm not the only one having this problem. I have also been checking within my work area and others are having exactly the same problem.
I'm sure it is something in the default settings in Project, I've just got to find it.
Lyric,
Are you absolutely sure you have Windows set for UK date format? When I tried a sample file, the dates appear in Excel just as they should - UK format (DD/MM). Also, make sure Excel is set to use UK format. Check it by selecting the worksheet column that holds the date data and go to Home/Cells group/Format icon. At the bottom of the drop down, hit "format cells". Select the Date category and make sure the Locale says English (U.K.).
John