Applicable products: Netmonitor, Netrivals

💡 Why are some EANs missing / in the wrong format on my report?

If you can't find your EANs when filtering the column, or if your EANs are displayed in the format 31735E+12, this is due to the default Standard format used by Excel for the column.

EXCEL_IjPOGdhlQx.png

Select the column and choose the "Number" format to display a correct format.

You must also remove the decimals by clicking the dedicated button twice.


https://support.microsoft.com/en-us/office/available-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2

EXCEL_3OsHyzMQff.png

-

Articles in this section

News, Services & Incident reports
Discover updates, webinars, and expert services to help you get the most from Lengow