EAN

/EAN

EAN

You will also find the EAN table under the heading Pricelist.

The EAN-table lists up all available parts of the current catalogue:
The following information is available amongst other things:

            • EAN-number,
            • Model number,
            • Item number,
            • Description,
            • Colour and Colour description
            • Purchase price
            • Single unit
            • Customs tariff number,
            • Weight per Sales Unit
            • Model description
            • Fitting,
            • Collection.

 

Excel does not display the EAN number completely?

If you enter very large numbers in a table, Excel automatically uses the exponential format for a certain number of digits or more. Thus the number 1.23E+13 stands for the number 12,345,600,000,000.

Excel uses the exponential format so that even large numerical values can be displayed in a column with a normal column width.

Unfortunately, Excel does not offer a basic setting that can be used to prevent the conversion to the exponential format. However, you can use formatting to prevent the conversion from being carried out:

      1. Select the corresponding cell range in your table.
      2. Call the CELL FORMAT function. You can do this in all Excel versions by pressing CTRL 1.
      3. Activate the COUNT tab in the following dialogue box.
      4. On the left side select the category COUNT.
      5. On the right side you will see a preview field showing the effect of the selected formatting.
        Below, you can define the required number of decimal places using a rotary field and
        determine whether the thousand separator is displayed in the cell or not.
      6. After confirming the formatting with the OK button, your numerical values appear in the
        desired format without exponential representation.