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?