Platform forum

Creating BOM from template

Lukas , 06-26-2016, 01:19 PM
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.
robertferanec , 06-26-2016, 01:30 PM
Lukas, 06-26-2016, 01:38 PM
Thanks! Perfect
ibocakir06 , 06-12-2017, 03:45 AM
So many thanks. This is so usefull.
JeffersonCe , 09-12-2017, 12:11 PM
Originally posted by ibocfakir06
So many thanks. This is so usefull.
Thanks Robert.
Use our interactive Discord forum to reply or ask new questions.
Discord invite
Discord forum link (after invitation)

Didn't find what you were looking for?