...
- Use the Jiwa Export Inventory utility as normal - export data to a csv file e.g. Export1.csv
- Open a new Book in Excel
- Save as csv file e.g. Export2.csv
- In the Data menu, select Get Data > From File > From Text/CSV
- Select the file created in step 1 - Export1.csv.
- The Query Editor will open
- Make sure the PartNo column is Data Type: Text
Use the Transform button to do this - Select Close & Load.
- Save Export2.csv
- You may now edit your csv file Export2.csv
...