I am including the dollar currency amount from a properly-formatted number field in a text calculation field. I want to be sure the dollar amount in the calculation field shows two decimal places. Now only both decimal places are show in the amount if there is an actual cents amount in both places of the current field. No zeros show for an full dollar amount and only one digit shows when there is only an amount in the tens field. I need both digits to show from the number field after the decimal point. I think I could just add the appropriate number of zeros if I could calculate how many characters were to the right of the decimal point when the number was converted to text. Thanks.

Have a look at the function made by Agnes Barouh it works with the NumToJText function, it is briljant! If you do not FileMaker advanced , just use it in a normal calculation.