try this

=TEXT(IMSUB(B4,C4),"$0")


On Nov 20, 11:26*pm, Bandit wrote:
I have a very simple worksheet with formulas. *Here is what I have:

ColumnB * * * * * * *ColumnC * * * * * * * * *ColumnD
Sales Amt * * * * * *Sales Return * * * * * * Net Sales

$591518.00 * * * * *$12638.00 * * * * * * * *$578880.00

My Formula for calculating Column D is: =IMSUB(B4,C4). *Column B & C shows
the $ sign. *When the calculation for Column D appears it does not have the
dollar sign. *The entire worksheet is formatted for currency with two
decimals. *I checked the individual cell and it is also formatted for
currency with two decimals. *What am I missing? *This is a school assignment.

Thanks

The
--
Bandit