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:
- Model number,
- Item number,
- Colour and Colour description
- Purchase price
- Single unit
- Customs tariff number,
- Weight per Sales Unit
- Model description
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:
- Select the corresponding cell range in your table.
- Call the command FORMAT CELLS. You can do this in all Excel versions by pressing CTRL 1.
- Activate the COUNT tab in the following dialogue box.
- On the left side select the category COUNT.
- 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.
- After confirming the formatting with the OK button, your numerical values appear in the desired format without exponential representation.