View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default EXCEL 2007 no longer add properly

Hi,

Did you recalcule the spreadsheet - press F9? If this is the problem, then
choose Tools, Options, Calculation, Automatic

--
Thanks,
Shane Devenshire


"pcor" wrote:

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