No announcement yet.

Creating BOM from template

  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating BOM from template

    I have issue creating BOM from template.
    In attached picture 1 you can see my generated BOM. Somehow EXEL is interpreted all numbers as text, so I get error. And this is begining of my problems, in my template are mathematical formulas which simple calculated total price of two “subtotal” columns, so it can’t calculate while it’s text...
    Yes, I know I can simple click on each “number” and convert it to number, but it is annoying… Also tried first convert all empty fields in my template to number format, but it did not help. Why Altium export numbers as text?
    Second problem is some numbers in “Supplier Unit Price 1” column are huge, in picture 2 we can see that before exporting BOM capacitor C6 price is 1.466$ and after exporting is 1466$, what the hell is wrong?
    I'm looking forward to your replies.
    Click image for larger version

Name:	1.JPG
Views:	230
Size:	426.7 KB
ID:	3155 Click image for larger version

Name:	2.JPG
Views:	193
Size:	342.3 KB
ID:	3156
    Attached Files

  • #2
    Maybe this will help you:


    • Lukas
      Lukas commented
      Editing a comment
      Thanks! Perfect

  • #3
    So many thanks. This is so usefull.


    • #4
      Originally posted by ibocfakir06 View Post
      So many thanks. This is so usefull.
      Thanks Robert.
      Last edited by JeffersonCe; 11-15-2021, 08:27 AM.