Hi there!

I'm looking for some help - I'm trying to create a drawing number register that automatically creates drawing numbers from selected data. However, when I link data to a "Drawing Number Cell", it leaves behind the 0.

For example I need to create a number such as, "LBA5-COY-02-00-M-1010" in one cell. The best I have so far is "LBA5-COY-2-0-M-1010", dropping the zeros from the 3rd and 4th part of the drawing number.

I've done this using the cell#&"-" to build this up. All off the data selected is based on VLOOKUPS and Lists from Data Validation.

It is important to have the 0 because it is the acceptable standards to which I have to work within. Take the 4th part of that drawing number (00), it relates to the Ground Floor, but if we show multiple floors on a drawing then that "00" needs to show "ZZ" instead. So I cannot just add a 0 manually to the formula because that could then read "0ZZ".

All data to which the cell is linked to has been formatted to show the correct value, i.e. ZZ or 00 but it doesn't carry over to the final number I'm trying to build.

Any ideas on how to bring those zeros across would be appreciated.
Thanks in advance