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
It is MONDAY I am just not seeing a solution.