Filler Zeros in a Field

[szaunbr]

I am working with CR9. I am working on a basic report that needs a numerical field (annual pay) displayed with filler zeros and an implied decimal.

Example:

12,649.23 should look like:

001264923

I tried writing a formula: totext({table.field},"000000000")

but this is returning 000012649

essentially losing the decimals.

 

[synapsevampire]

Try:

totext({table.field},"0000000.00")

Or try:

replicatestring("0",9-len(totext({table.field})

-k

 

[synapsevampire]

Ooops, I meant:

Or try:

replicatestring("0",9-len(totext({table.field}) & totext({table.field},2,"")

-k

 

[hassellhorse]

You can also use the formula:
Right("00000"+{fieldname},9).