EAN

/EAN

EAN

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.

 

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.