cancel
Showing results for 
Search instead for 
Did you mean: 

leading zero

Former Member
0 Kudos

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")

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Try:

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

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

Getting the error A string is non numeric

Former Member
0 Kudos

Hi Abhilash,

Sorry My mistake.Its working fine

Answers (0)