5 Replies Latest reply on Mar 12, 2009 7:21 AM by jkeebler

    Creating a calculation with the results containing currency symbols ($1,000.00)

    jkeebler

      Title

      Creating a calculation with the results containing currency symbols ($1,000.00)

      Post

      For the life of me, I cannot figure out how to create a calculation with results that contain currency symbols.  I need to take a total amount and divide it by half.  The half amount will be in a letters sent to college scholarship recipients (they get half for the first semester and half for the second semester).  I know that I can put the dollar sign here $<<half amount>>, but I'm stuck on combining the comma, decimal and ending zero's.  So far my calculation looks like this:  totalamount/2&".00", which gives me 1000.00, but no comma.

       

      I'm probably making this way more complex than it is, so I would truly appreciate any help!!