AnsweredAssumed Answered

Leading zeros with Part Lister to Excel

Question asked by aaron.cramer on Sep 26, 2013
Latest reply on Nov 24, 2014 by robert_davies

Hello,

 

Is there a way to retain leading zeros when exporting a BOM using the Part Lister to an xls file?

 

One of my columns is PKG_TYPE which contains the value "0603" among others.  When I export the BOM to an .xls file, I lose the leading zero and am left with "603".  If I export to text, then import to Excel, I can define that column to be text on import, in which case I get my leading zero.  I would like to eliminate this intermediate step, if possible. 

 

Thoughts?

 

Thanks!

Outcomes