Adding leading zeros to serialnumber

1

Hi There!

After searching the forum and coming to some awseome ideas, i’m really close (I hope)

I have a button which generates a sequential number, which is in the column “CMPR”. Now I would like to add leading zero’s to the serialnumber. The problem comes when the number changes form 9 to 10. Now my serial number is 5 digits and I want to limit to 4. Does anybody have a idea?

The formula I use in the second column is this:

Concatenate(“CMPR”,“000”,thisRow.CMPR)

2

Funny thing about researching a solution is thet when typing it out, you stumble across a possible solution and voilá. I just added a third column and used the Leftpad formula. Then in the last column i used Concatenate to add all the parts.

I’m still somewhat in excel mode and making huge formulas, nesting them and so on…

Anyway, thanks for the help :slight_smile:

3

hi peter,

did you consider the function Format()

image
image1550×802 63.4 KB

Enjoy, Cheers, Christiaan

1 Like
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.