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 reports in MarinOne is configured by the Locale setting, which you can access by following these steps:

  1. Click Admin module in the bottom-left.
     
  2. Click on the Clients & Users tab and the Clients sub-tab.
     
  3. Double click on the desired client to launch its settings in the Side Panel. 
     
  4. Under the Geographic section, hover over the Locale field until the Edit button ('pencil' icon) appears, then select it.
     
  5. Change the locale as necessary.
     
  6. Click Save.  

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 Customer Support team.

 

Last modified

Tags

Classifications

(not set)
(not set)
(not set)

 

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