Remove decimal separator & always have field length at ten

[cvgalloway]

I need to find a way to edit a currency field with a formula to remove "," and decimal points and to have the result 10 digits long. For example, 12,866.90 would need to be 0001286690. I cannot simply do this with the "format field" option on the report as that does not actually chance the data but only the way it displays. I need the data changed as it is to be exported.

Thanks
Catherine

 

[lbass]

Try:

totext(tonumber({table.currency})*100,"0000000000")

-LB