Padding a fixed number with leading zeros up to a

Question

In Crystal Report using Visual Studio 2010, I am trying a to create a formula for the following scenario:

x = any number (Fixed number of 8 digits, cant be less or greater)

If Length of X is less than 8, pad the required amount of 0's in the front to make its length 8.

Eg:

X = 123
Result of Formula should be 00000123

X = 9
Result of Formula should be 00000009

Any help will be appreciated. Thanks in advance.

Answer 1

I got it

Right("0000"&{MyFieldToPad},8)

Works perfectly as I want it to.

Answer 2

ToText({table.field},"00000000") is more succinct.