When creating a report, you may notice the data sometimes uses 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.
This problem is caused because the locale of your MarinOne client account is different from that of your Excel. Here is an example situation:
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 |
You can fix this issue in either of the following ways:
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 MarinOne client account. Please refer to the article Formatting Errors When Running Reports With Different Locale Setting for step-by-step instructions.