How to show leading zeros in numbers when exporting a BOM from SolidWorks?

When I am exporting my BOM from SolidWorks it does not show the leading zeros in my 'Stock Number' column. How can I fix this?

1 Answer

Exporting to Excel?
Excel doesn't like leading zeros. I think for it to work you'll need to set the cells to be text values, or prefix the entries with another character.