12 Replies Latest reply on May 2, 2015 11:12 AM by Allin

# Number to Text for printing bank checks

### Title

Number to Text for printing bank checks

### Post

This is for a layout to US bank checks.  I need to change the amount number to text.  I found a calculation, but I need to modify it. The result looks like this: Eleven Thousand; Two Hundred Fifty Three  Dollars and Eighty Five Cents.  I need it to look like this: Eleven Thousand; Two Hundred Fifty Three  and 85/100

Thank you.

• ###### 1. Re: Number to Text for printing bank checks

Try about 8 lines up from the bottom, removing:

& Case(Int(NumberField) > 1; "Dollars"; Int(NumberField) = 1; "Dollar"; "")

and the last 2 lines:

& <<<<<<<<<<<//at the end of next to last line

Case(Mod(NumberField; 1) > .01; "cents"; Mod(NumberField; 1) = .01; "cent";"")

• ###### 2. Re: Number to Text for printing bank checks

Yeah. That's what I tried too, but that leaves me with: Eleven Thousand; Two Hundred Fifty Three  and Eighty Five .  I still need to get the cents to 85/100.

• ###### 3. Re: Number to Text for printing bank checks

( Round ( numberfield ; 2 ) - Int ( numberfield ) ) * 100 & " / 100" )

• ###### 4. Re: Number to Text for printing bank checks

Fantastic. Thank you! Now to figure out if I can format the filed to fill in the remaining available space with asterisks.

• ###### 5. Re: Number to Text for printing bank checks

I would just put & "***********************************************************" at the end of the calculation and let the field on the layout clip the extra asterisks.

• ###### 6. Re: Number to Text for printing bank checks

So far, I have been unable to find a way to get the field to clip the extra asterisks.  It just puts them on the next line.  It doesn't look like I can limit the number of characters in a calculation field either.  I might be able to get by if I could edit the field in browse mode manually, but being a calculation, the only way is from within the calculation formula.

Edit:  I think I got it.  I created another calculation field and used the Left function to clip the number to text calculation result.

• ###### 7. Re: Number to Text for printing bank checks

The problem with the left function is that it counts characters and characters vary in width so the number that fills a given field will vary with the particular characters. Numbers are more consistent than letters when it comes to width so this might work well enough. The left function can be used to enclose your entire calculation as a way to avoid having yet another calculation field in your table.

But you are right, the field isn't clipping the text like I thought it would when I do a quick test of this.

• ###### 8. Re: Number to Text for printing bank checks

Was wondering if would be easier to add 10 asterisks at the front of the calculation and format the field for right alignment.  Seems like you don't wont someone to add on to the amount in the front.  I tried playing around with a custom function from the FileMaker Training Series that adds dots to the end of a string (like in a menu), but can't get it to work properly

• ###### 9. Re: Number to Text for printing bank checks

Just put 3 or 4 asterisks before and after.  That will be sufficient to show no tampering.

• ###### 10. Re: Number to Text for printing bank checks

Thanks for the all the help and suggestions.  The layout is for printing checks, so the font will not be changing. The left function works well for filling ensuring all the space is filled.  It took a few tries to figure out the number of characters, but now it works fine. The checks look just like the ones Quickbooks generates. I created a different table style layout that I can send to the bookkeeper at the end of the month.

The next thing I will do is create a drop down menu of our common vendors and then use a Case function to auto populate the address fields.

I'm surprised this isn't a starter solution, since laser printed checks are so common for small businesses.

• ###### 11. Re: Number to Text for printing bank checks

A case statement is not needed.  Hopefully you have the vendors set up in a table.  Then when writing the check, a drop down to select the vendor.  Populate the address with related fields from the vendor table.

• ###### 12. Re: Number to Text for printing bank checks

Thank you TK, I will do that.