Leading Zeros? 1

[Yustrn]

How do I place a formula to enter in leading zeros on a number for instance I need to hold 10 places so

101 should be 0000000101
1001 should be 000000101
10001 should be 0000010001
so no matter what the number is I need 10 fields and the fields should be leading zeros. This is using Crystal 10

Thanks!

 

[lbass]

Use:

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

-LB

 

[bdreed35]

If the datatype of your field is a number, then use lbass's solution.
If your field is already a text, you can do something like this:

right(replicatestring("0",10) & {table.field},10)

~Brian