leading zero

30 Views

Hi All,

May be ti is a small one.

I need display like this.

01

02

03

..

.

10

11

If it is a single digit I need to show leading zero.

I tried like this but getting error.My field is string

ToText (ToNumber({TenderName.MEDIA_NO}),"0")