Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help formating a cell | Excel Worksheet Functions | |||
Formating cell | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
CELL FORMATING | Excel Discussion (Misc queries) | |||
Cell not formating | Excel Discussion (Misc queries) |