JNeuhoff: Export/Import Tool (V3.5) - EAN problem

Hi,
when I import product xlsx where I have EAN it apperas in format 4.123454E, instead of regular number.
In excel it appear fine, format is also correctly set.
Any way to fix it?

kudykam wrote:Hi,
when I import product xlsx where I have EAN it apperas in format 4.123454E, instead of regular number.
In excel it appear fine, format is also correctly set.
Any way to fix it?

I am unable to reproduce your problem, the EAN code is a text string, and appears just fine in the spreadsheet, and imports without changing it.

Looks more like an issue with MS Excel. Use OpenOffice or LibreOffice and enter the EAN codes as text-formatted strings, not as numbers.

Saving format as ODS helped.