AnsweredAssumed Answered

Item number formats

Question asked by Peter Ham on Jul 9, 2012

Hi all,

 

I've been working on creating an Excel template for our BOMs, and have come up against a problem whereby excel treats item 1.10 as equal to 1.1. While of course this is mathematically correct, it doesn't help when using certain lookup functions.

 

I'm hoping that there is a way to create the item numbers in Solidworks such that they follow:

 

1

1.01

1.02

.

.

1.10

1.11

etc

 

I've not been able to find any way to achieve this so far, is it possible?

Outcomes