How do I rectify date and time formatting issues when exporting data into Excel? (Power Surveys)

This article illustrates how to update the Regional and Language settings in Windows when date/time data in Excel is incorrectly formatted.

This issue is specific to the data for common questions that are being exported, such as:

• PanelistJoinDate
• LastParticipationDate
• LastInvitationDate
• Date Questions (i.e. any data displaying DATE and TIME)

The issue results in different, inconsistent formats for date and time being used throughout the whole Excel sheet.

Example

The reason why this occurs is due to Windows' Regional and Language settings, and how the application formats the exported data.

Detailed Steps

Solution for Windows 10

1. Click on Start and go to Settings.
2. Click on the Time & Language.
3. Click on the Date & Time.
4. Under Formats section, the Short date needs to be change from dd-MMM-yy to M/d/yyyy. 
   
5. Click Apply and then OK.
6. Download the Excel file again from the application and reopen for the changes to take effect.

Solution for Windows 7

1. Click on Start and go to Control Panel.
2. Click on the Clock, Language and Region option and then select Region and Language.
3. Under Formats tab, the Short date needs to be change from dd-MMM-yy to M/d/yyyy.

4. Click on Apply and then OK.
5. Download the Excel file again from the application and reopen for the changes to take effect.

Solution for Windows XP

1. Click on Start and go to Control Panel.
2. Click on Region and Language.

3. Click the Regional Options tab, under the heading Standards and formats, select English (United States).
4. Select the Customize button and click the Date tab.
5. Under the heading Short date format, change this change from; dd-MMM-yy to M/d/yyyy.

7. Download the Excel file again from the application and reopen for the changes to take effect.

More Information

Read this WebHelp article to learn more about Export Data.