AnsweredAssumed Answered

BOM Save to Excel Missing Leading Zeroes

Question asked by Andrew Johnson on Nov 8, 2017
Latest reply on Aug 7, 2018 by Giovanni Strasorier

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

EXCEL_2017-11-08_17-11-38.png

Outcomes