We use cookies in order to give you the optimal experience of our website. Some of them are required for the operation of this site (e.g. in order to use the shopping cart). Others allow us to enhance our online offers and to display them efficiently. You can use the settings to determine which cookies you will permit. Further details can be found in our privacy policy.
Settings
  • Required
    These cookies are required for the functionality of this site, e.g. by making it possible to add products to the shopping cart. Furthermore, this type of cookie guarantees that you can log into your account and that you can stay logged in, in order to maintain access to your order details. Required cookies are exclusively used on this Website. No data is transferred to third parties.
  • Comfort
    These cookies allow the custom tailoring of certain features in order to enhance the user experience and simplify the use of our site.For instance, they make it easier to search for and find suitable products. Cookies used to enhance the user experience are exclusively used on this site and no data is passed on to third parties.
  • External Media
    We provide you additional media, e.g. videos or maps. This media is provided by third parties, who are using cookies.Cookies for external media is used by third parties or publishers. We do not have any control about this cookie usage.
  • Statistics
    In order to further improve our Website, we collect anonymous data for statistics and analysis. These cookies enable us to keep track of traffic which helps us improve the site systematically. For these purposes, only anonymous data is passed on to third parties.
  • Marketing
    Marketing cookies help us to inform you about interesting offers on other websites. Marketing cookies are used by third parties or publishers in order to present personalized adds.

Edit EANs correctly in Excel

Questions:

  • Excel turns my EAN into a strange number. How can I prevent this?
  • Excel is ruining my EAN. What do i have to do?

Description:

Excel often interprets EANs (European Article Numbers) as a number. This in itself is a problem because it causes Excel to remove leading 0s. Due to the length of the number, Excel also converts the number into an exponential number. This makes further editing of item lists very difficult.

Excel converts it to exponential numbers

Here you will find instructions on how to prevent this in Excel.

Solution:

To prevent Excel from processing EANs incorrectly, you need to stop Excel from interpreting the column as a number. Instead it should be interpreted as EAN.

  1. Select the entire column in Excel by clicking on the column.
  2. Right-click the selection and choose "Format Cells."
  3. Select “Text” as the format.

Tips und Tricks:

When you open an Excel or CSV file for the first time, Excel automatically converts the column into a number and thus into exponential numbers by default. As long as you haven't changed the file yet and proceed as described above, Excel can still display the EAN correctly because they are still in the internal memory. However, once you close the file, the correct values are usually lost.

Subscribe to our newsletter

Stay informed at all times. We will gladly inform you about product news and offers.