Help Center

Articles in this section

Decimal Symbols in Excel Exports

With this option, you can decide on "decimal symbols" which are used in your Excel Exports to separate the decimal places. There are three options here:

 

Screen_Shot_2019-04-25_at_10.09.41_AM.png

 

  • Leave as Default(1): If you select this option, the numeric data in your Excel file ( prices, costs, smart prices ) will be stored as "number" which means you can include these in your formulas like =SUM, =AVG. The decimal symbol will be dot or comma according to your preferences on your computer. You can find how to change this option on your computer below:  
    • MacOs: Click the "Apple" button from the top left corner and go to "System Preferences". Then, select "Language & Region" and click advanced. On the next page, you'll see grouping and decimal symbols that are used. You can edit them according to your preferences and the decimal symbols in your Excel reports will be shown accordingly. 

                 Screen_Shot_2019-04-18_at_12.17.54.png

                 advanced.png

    • Windows:
      • Windows 7: Be sure that Excel is closed. Then follow this path: Windows/Start button > Control Panel > Region and Language > Formats Tab > Additional Settings > Change the Decimal separator according to your needs and save it. 

                             

      • Windows 8/10: Be sure that Excel is closed. Then follow this path: Start > Control Panel > Regional and Language Options ( Region for Win 10 ) > Additional Settings > Change the Decimal separator according to your needs and save it. 

 

  • Force Comma(2): If you select this option, the decimal symbols in your account will be always comma (,) however this also requires that the numeric data in your Excel file ( prices, costs, smart prices ) will be stored as "text" which means you might have difficulty to use the data in your formulas.

 

  • Force Dot(3): If you select this option, the decimal symbols in your account will be always dot (.) however this also requires that the numeric data in your Excel file ( prices, costs, smart prices ) will be stored as "text" which means you might have difficulty to use the data in your formulas.

 

What we strongly suggest you is to use the first option, "leave as default" and change your preferences on your computer according to your needs.

Related articles