View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bandit Bandit is offline
external usenet poster
 
Posts: 4
Default Need help with formating cell

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