Loading

Incorrect Date Format When Exporting the View As a Crosstab

Дата публикации: Apr 13, 2024
Описание
When exporting as crosstab a workbook created in a different locale, Excel does not recognize the chosen date format.
Решение

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.
Номер статьи базы знаний

001498396

 
Загрузка
Salesforce Help | Article