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')
Perfect! Worked! Thank you!
That solution works only with numbers ...
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
Retrieving data ...