Wondering if anyone else has run into this issue and if you have a solution.

When you export an Indented BOM to Excel, and you're using Detailed Numbering, Excel truncates items with trailing zeroes and therefore shows different part numbers with the same item number. See attached screenshot: