| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Prevent negative numbers from changing to positive in calculation
On worksheet Page 1 (for example), I have referenced a group of numbers to
calculate from worksheet Page 2. All the numbers in this reference group are negative numbers, but the calculation shows them as positive numbers. This is not the case for every calculation but occurs sporadically within this file. The formula of the negative numbers shows them with a '-' preceding the number. The formula of the calculation shows '=sum(cells referenced on Page 1). Why is this happening and how can it be fixed? HELP!! Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing positive values to negative | New Users to Excel | |||
| Changing a cell color to reflect positive or negative total | New Users to Excel | |||
| Changing formuals from Positive to negative | Excel Discussion (Misc queries) | |||
| Changing Positive to Negative | Excel Worksheet Functions | |||
| simple query changing set of numbers from positive to negative | Excel Discussion (Misc queries) | |||
Threaded Mode
