Welcome!
Welcome to the Marin Software Support Center. We're glad you're here. Here's what you can look forward to:
  • Real-time search so you can find what you need faster than ever.
  • Easy-to-follow video guides for our most popular articles.
  • Interactive simulations and Live Screenshots to make learning easy.
  • Regular content updates to ensure every word you read is accurate and up-to-date.

Reports In Marin

Home > English > Reports In Marin > Creating Reports and Alerts > Troubleshooting Articles: Creating Reports & Alerts > Configuring Date Format in Reports

Configuring Date Format in Reports

What is the issue?

When creating a report, you may notice the data gets commas. The commas could make the date unusable in Excel, as Excel would use commas not as a delimiter for thousands, but as a separator for decimals.

what causes the issue?

This problem is caused because the locale of your Platform account is different from that of your Excel. Here is an example situation:

  • Your locale of the Platform is English US:
    • A comma (,) is used for 1000 separator, and a period (.) is used to separate the decimals such as this: 1,234.56
       
  • Your locale of Excel is French:
    • A comma (,) is used to separate the decimals, and a space ( ) is used for 1000 separator such as this: 1 234,56

Below you can find a few examples of locale settings in the Platform with examples:

 

Locale

Example

Danish (Denmark)

1 234,56

English (United Kingdom)

1,234.56

English (United States)

1,234.56

Finnish (Finland)

1 234,56

French (Canada)

1 234,56

French (France)

1 234,56

German

1.234,56

Italian

1.234,56

Norwegian

1 234,56

Spanish 

1.234,56

Swedish 

1 234,56

 

How to fix the issue

You can fix this issue in either of the following ways:

  • Change the Platform account locale to match your locale in Excel.
     
    1. Click the Admin link in the upper-right.
       
    2. Go to the Clients sub-tab and click the client account name.
       
    3. Change the Locale setting to match the locale.
       
  • Switch Excel settings on delimiters.

 

Note: There might be occasions where you have to run a report in a format that is different than the one defined in the Locale setting in your Marin account. Please refer to the article Formatting Errors When Running Reports With Different Locale Setting for step-by-step instructions.

 

Last modified

Tags

Classifications

This page has no classifications.

 

wiki.page("Internal/Mindtouch_Launch_Sandbox/js.cookie.js")