Tweet
Hello,
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.
Thanks!
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.
Thanks!
Attached Files
Comment