Leading 00 to Integers

Hello All,

Trying to reformat numbers with leading 00s, such that:

1 = 001
2 = 002
10 = 010
42 = 042
100 = 100 etc

I’ve done it before with the expression tool and Format, something alonfg the lines of “Format(”{000}", x)" but I’m having a massive blank now.

Before there were posts on the old forum solving this. For all the faults of Ning, and how clean this looks, I find it a real shame that many years of help and knowledge is now barely searchable.

Many thanks,
Joe

{0:000}

The first number inside the curly brackets identifies which item you’re formatting (there’s only one, so it must be 0), the bit after the colon specifies the type of formatting.

That’s perfect. Thanks for such a swift reply and explanation!