Padding a fixed number with leading zeros up to a fixed length

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.

Accepted Answer

I got it

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

Works perfectly as I want it to.

Padding a fixed number with leading zeros up to a fixed length

Solution

Problem