S

#### Scott

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