Adding Deciamls to a Field

[mrules45]

I have a dollar value field and i need it to always have decimals to the 100th place at the end of the number. How can i achieve this?

[comment]

You could either format the field to display as decimal with a fixed number of decimal digits, or (if you need this in a calculation with a Text result), use:

Let (

a = Round ( YourField ; 2 )

;

Int ( a ) & SerialIncrement ( ".00" ; 100 * Mod ( a ; 1 ) )

)

This assumes your amount will never be negative. And that you mean TWO decimal places, not 100.