Loading

Date Values Appear Corrupt in Salesforce Report Export to Excel Due to Locale Mismatch

Julkaisupäivä: Oct 7, 2024
Kuvaus

When working within an Excel file exported from a Salesforce report, changing the cell format to "Date" for cells containing date values may return inaccurate information or display dates as "General" format.


This occurs when the locale settings of your Excel platform (controlled by your computer's locale settings) differ from the locale settings defined in your Salesforce interface.


Example: If your computer uses American date format (MM/DD/YYYY) but your Salesforce locale is set to a format that uses DD/MM/YYYY (such as United Kingdom), you would have a date like "30/11/2012" exported from Salesforce. Excel (set to US locale) will not recognize "30/11/2012" as a valid date because "30" is not a valid month. Excel then formats the cell as "General" instead of "Date."


Note: Salesforce report exports offer two download options — Formatted or Details Only. For more information, see Salesforce Help on Report Exports.

Ratkaisu

To resolve this issue, align the locale settings between Salesforce and your computer.


A. To Change Your Salesforce Locale Settings

  1. Access your personal settings:
    1. In Lightning Experience: Click your user image | Settings | Language & Time Zone.
    2. In Salesforce Classic: Click Setup | My Personal Information | Personal Information | click Edit.
  2. In the Locale Settings section, click the Locale picklist and select the same locale as your computer.
  3. Click Save.

B. To Change Your Computer Locale Settings
If changing your Salesforce locale is not an option, you can change your operating system locale to match your Salesforce locale setting.

 

After aligning the locales, re-export the report from Salesforce and open it in Excel. Date values should now display correctly.

Knowledge-artikkelin numero

000385810

 
Ladataan
Salesforce Help | Article