Ook kunt u hier de EAN bestand vinden.

De EAN-tabel geeft een overzicht van alle onderdelen
die beschikbaar zijn in de huidige catalogus, zoals onder andere:

  • EAN-nummer,
  • Modelnummer,
  • Artikelnummer
  • Omschrijving,
  • Kleur en kleurnaam,
  • Aankoopprijs,
  • Maten,
  • Douanenummer (productnummer),
  • Gewicht / eenheid,
  • Model Beschrijving,
  • Pasvorm,
  • Collectie.

In this way you ensure that even long numbers are not displayed in exponential format, but with many digits.

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.

As practical as automatic conversion is in many cases, it is annoying if you create wide columns in advance, because you need exactly these large numbers.

Unfortunately, Excel does not offer a 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 command FORMAT CELLS. 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.
        6. 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.
        7. After confirming the formatting with the OK button, your numerical values appear in the desired format without exponential representation.