EAN

/EAN

EAN

Vous trouverez également le fichier EAN ici.

Le tableau EAN liste toutes les pièces disponibles dans le catalogue actuel.
Les informations comprennent entre autres :

  • Numéro EAN,
  • Numéro de modèle,
  • Numéro d’article,
  • Désignation,
  • Couleur et désignation de la couleur,
  • Prix d’achat,
  • Taille unique,
  • Numéro de tarif douanier (code marchandise),
  • Poids / unité de conditionnement,
  • Description du modèle,
  • Coupe,
  • Collection.

 

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.