When exporting files to .csv the leading 00's disappear on the part numbers and any other fields which have leading 0's. Is there a way to stop this happening as it is a pain every time we export.

By: Guest

Posted on: Sep 4 2017 at 07:05:50 PM

Minimrp shouldn't remove leading zeros from part numbers.

But if your part numbers are numerical then, when you open the file with excel, excel will convert to numbers which won't include leading zeros. So i suspect that it's excel that's removing your leading zeros.

Export a csv from minimrp and then Try opening the csv file with notepad instead of excel. In notepad the data will look very strange but you should be able to see if your part numbers still have the leading zeros.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.