Fixed length field

[enterprise1177]

Field name is APPAYM and it's a number field. For example 12250.12 I need it to appear for the bank as 000001225012
Any suggestions would greatly appreciated.
Using Crystal IX

Thanks Bill D.

 

[Charliy]

TOTEXT({APPAYM}*10,"00000000000000")

You may need to do a formula for {appaym}*10 and put it in the totext

 

[enterprise1177]

Thanks for the formula. I ended up using totext({APPYM.AMTPAYM},"0000000000.00")
I had to enter the decimal point to get the cents to appear. I need to remove the decimal point but still have the cents appear.
Any thoughts

 

[enterprise1177]

I ended up using this formula and it works.
totext({APPYM.AMTPAYM},"0000000000") + Right (totext({APPYM.AMTPAYM},"0000000000.00"),2)
I sure there is a cleaner way of doing it but it works.

 

[BettyJ]

You can use the formula suggested by Charliy with the following changes:
TOTEXT({APPYM.AMTPAYM}*100,"000000000000")

 

[Charliy]

Oops, I meant 100, not 10