Need to add leading zeros based on length

[ComputerNurse]

I am trying to write a formula to add leading zero's to
a number that will have varying lengths. The pic clause
I am trying to create is 9999.99, the original length varies. Is there an easy way to do this? Any help would be appreciated as I am new at this.

 

[synapsevampire]

The decimal point causes a small hitch, otherwise it's very simple so I'll make the assumption that you do not have anything with a value less than 1.

Create a formula something like:

if len(totext(2345.67,2,&quot;&quot) < 8 then
replicatestring(&quot;0&quot;,8-(len(totext(2345.67,2,&quot;&quot)))+totext(2345.67,2,&quot;&quot

Replacing the 2345.67 with your field.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

You can add the leading zeros by using a mask in the ToText function.

ToText({table.field},&quot;0000.00&quot Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm