KNOWLEDGE BASE

Incorrect Date Format When Exporting the View As a Crosstab


Published: 31 Jan 2017
Last Modified Date: 13 Nov 2017

Issue

When exporting as crosstab a workbook created in a different locale, Excel does not recognize the chosen date format.

Environment

  • Tableau Server
  • Microsoft Excel

Resolution

Option 1

In Microsoft Excel:
  1. Select the column of dates
  2. Click Data > Text to Columns.
  3. Click Next.
  4. Click Next.
  5. In step 3 of the wizard, check "Date" under Col data format, then choose: "MDY" or "DMY" as needed from the dropdown menu
  6. Click Finish.

Option 2

Change the Windows locale settings to match the settings of the workbook.
Did this article resolve the issue?