đź’ˇ 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

See more
Access help center for our Channel Execution solutions
NetAmplify & NetMarket