Add leading zero's to a field 3

[munzza]

I am trying to create a crystal report that pulls data from a customer order screen in our business system to be exported to a text file and sent to one of our customers. The field is a customer order line number e.g 32 The customer requires this field to be 5 charactacters in length with leading zeros e.g 00032. Can someone help me with the formula to perform this conversion?

Thanks in advance!

Munzza

 

[tip4you]

numeric field:
right("00000" + totext(number,0), 5)

alphanumeric
right("00000" + number,5)

where number is your "line number

 

[lbass]

Try:

totext({table.number},"00000")

If it is already a string, then try:

totext(val({table.string}),"00000")

-LB

 

[munzza]

Thankyou for the tips. They worked exactly as needed!

Munzza.