Hi, i wonder if you can help me on how can i get an automatic and sequencial code for my invoices number...
I need it to be like this: 0001-00000001 / 0001-00000002 and so on and so on...
I tried Concatenate, but the thing is i cannot figure out how to stablish the lenght of the number cannot exceed the 8 digits after the "0001-"
Thanks!
Solved! Go to Solution.
CONCATENATE(
"0001-",
RIGHT(
CONCATENATE(
"0000000",
InsertFancyExpressionForSequential
),
8
)
)
CONCATENATE(
"0001-",
RIGHT(
CONCATENATE(
"0000000",
InsertFancyExpressionForSequential
),
8
)
)
Thank youuu!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |