Home Button  Buy Button 

Topic:   Exporting to .csv removes leading 00's

By: PeteMPosted on: Sep 4 2017 at 02:40:03 PM
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: GuestPosted 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.

Topic:- Exporting to .csv removes leading 00's

Enter the numbers.

Your name here is optional