Creating a calculation with the results containing currency symbols ($1,000.00)
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!!