When I save a BOM to Excel, any field that contains leading zeroes in SolidWorks is trimmed to remove them in Excel. Not sure if this is an issue with the way SolidWorks creates the Excel file, or the way Excel treats it when it is opened. Does anyone know a way around this?

Thanks

SolidWorks (Note the Part Number field, line 2)

Excel