You can format a merge field as well. So if you insert the total calc field as a merge field on your layout, you can use the number formatting on that as well.
Thanks for the replay, but I need the "150,00" in a calculated script result, I don't use a merge field.
Thanks a lot
I don't use a merge field.
Then how does it "show in a text on the layout for billing for example"? If it's on the layout, it's best to use layout-level formatting. If you need it for something else, e.g. e-mail, you can use =
"€ " & Int ( Amount ) & SerialIncrement ( ",00" ; 100 * Mod ( Amount ; 1 ) )
Note that the result of the calculation must be Text, and Amount must be a non-negative number pre-rounded to 2 decimal places.
Then how does it "show in a text on the layout for billing for example"?
I'm developing a database for a Legal Office, so I'm making many "autocompiled" templates of letters and court acts. I prefer to use scripts for making the texts, and I use very much variables ($), and the script exports the created text automatically in Apple iWork Pages by an applescript.
So, many times I need that some sentence are in the middle of the paper.
Now I try your suggestion.
Thanks a lot
Ops ... this my last reply is about an other mistake ....
Anyway, the way is the same, when I export the text on Pages, I need that the decimals are show as be ,00 too!