I have a formula listed below that is displaying 3 decimal places no matter
what I set the cell number formatting to from the menu. Also you can see I'm
including the "$" symbol in the formula just because that's the only way I
can keep my alignment correct on the sheet.

Is there any excel formula functions that could force my below function to
only display 2 decimals? I also have a problem with the formula results when
the decimal displays as 1 decimal place. Basically I'm looking for a way to
force the formula to return 2 decimal places no matter what. It would also
be nice to force the results to display the thousands comma. The cell format
bdialog options don't seem to work on my results because I'm concatenating
the "$" sign.

Any ideas?



FORMULA:
="$ " & (E9/1000)*125


RESULTS:
$ 532358.375