TKnTexas55

Formatting a Number to Text

Discussion created by TKnTexas55 on May 21, 2018
Latest reply on May 21, 2018 by beverly

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. 

Outcomes