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 > Formatting Errors When Running Reports with Different Locale Settings

Formatting Errors When Running Reports with Different Locale Settings

Introduction

The format of the reports in the Marin platform is configured by the Locale setting which you can access by following these steps:

  1. Click the Admin link in the upper-right.
  2. Go to the Clients sub-tab and click the client account name. To access this section of the Marin platform, you will have to have the Admin-level access to this Marin account.
  3. You can view the Locale setting in the Client Info section.

You can learn more about changing the Locale of a Marin account in the Unnecessary Commas in Platform Reports article.

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. We will walk you through the steps on how to correct this type of formatting issues in Excel.

Resolving Formatting issues

To correct your formatting issues:
 

  1. Open Excel.
     
  2. Navigate to the Data tab.
     
  3. In the Get External Data section, select From Text.
     
  4. Next, import the report showing the incorrect values. 
     
  5. The Text Import Wizard will launch.
     
  6. Step 1 of 3: Make sure the Delimited checkbox is selected, then click Next.
     
  7. Step 2 of 3, click Next again.
     
  8. Step 3 of 3, click Advanced.
     
  9. In the Decimal separator box, write a comma. In the Thousands separator box write a dot. Then, click OK.
     
  10. Click Finish.
     
  11. Go back to the worksheet and check that all the numbers are now displayed with the new separators. 
     
  12. Save the worksheet as a .csv file and confirm by opening in another program, for example, Notepad.

 

That's all there is to it! If you have any questions, please don't hesitate to reach out to our Support team who will be happy to assist you.

 

Last modified

Tags

Classifications

This page has no classifications.

 

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