Hi all,

I would like to format a number field that is storing a currency amount in a text calculation, but how do I add the number formatting in a script? I use NumToText(Total), but it just appears without decimal places like this:

2000

I want it to appear as follows:

$2000.00

I guess I can add the "$" char manually, but how do I get 2 decimal values to always print?

This has been asked before:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=39018&Forum=UBB16&Words=number%20format&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=allposts&Main=38977&Search=true#Post39018

Thank you, it did not show up in the search I ran before posting.