Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
If I have item numbers, that come in in various lengths, say, 3 to 5 characters, but I want to make them all 6 characters long, how do I do that? I've looked everywhere but can't find any topics pertaining specifically to this, thanks for your help.
Try it with num(Field, '000000')
- Marcus
If your field name is for example myField then:
=Repeat('0',6-Len(myField )) & myField
let me know
yes Marcus is correct you will get your numbers followed by 0 (zeros)
ex for 10 you will get 000010
Perfect! Worked! Thank you!
That solution works only with numbers ...