Indented BOM Export to Excel - Item Numbering Issue

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:

This issue has been around for a long time. You need to export the BOM to text file instead in import it into excel via "text import wizard" and make sure you force the column data format to "text". If you google "import text excel macro" you will find plenty samples that will let you automate the import part with a simple click. I have found the text export function to be the only reliable way.

Somebody mentioned you can also force Excel to not drop trailing zeros, however I was never able to find a way to do that.

This issue has been around for a long time. You need to export the BOM to text file instead in import it into excel via "text import wizard" and make sure you force the column data format to "text". If you google "import text excel macro" you will find plenty samples that will let you automate the import part with a simple click. I have found the text export function to be the only reliable way.

Somebody mentioned you can also force Excel to not drop trailing zeros, however I was never able to find a way to do that.