I am moving my check registers to FileMaker Pro. Currently these are in Excel. I am trying to create the banking field for positive payment. I am concatenating five fields as text. I am stuck on the check amount.

Using GetAsText(CkAmt) the amount may be **99999.99 **or **99999.9 **or **99999**. The amount has to be text, but has to be formatted to two decimal places. In Excel, I used

=TEXT(E171,"###.00")

It is MONDAY I am just not seeing a solution.

Why format a number as text?