I have a formula and then a label concatenated onto the end which works fine
but now I realize I have to format the numeric portion since it is working
with too many decimals. I know how to do this in access but not excel.

The formula is:
=IF(F10-H100,(F10-H10) &" LOSS",(H10-F10) & " PROFIT")

In msaccess, I would just add:
=IF(F10-H100,format((F10-H10),"fixed") &" LOSS",format((F10-H10),"Fixed") &
" PROFIT")

How do I do this in excel??