View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
robbin robbin is offline
external usenet poster
 
Posts: 2
Default 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!!