View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default EXCEL 2007 no longer add properly

In cell k17 I have the number 1
in cell l17 I have the number 2
in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be)
Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the
answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20
and l20
What has gone wrong?
Thanks