Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

adding cells wrong

Discussion in 'Information Technology' started by brian, Jul 28, 2006.

  1. brian

    brian
    Expand Collapse
    Guest

    I have the following numbers in the B2:B17 (b2 thru B17 cells) and when I
    highlight the B2:17 cells to add I get a total of 20 (I have d\formatted the
    cells as numbers and also tried gerenal) but will not total correctly any
    suggestions?
    9
    9
    11
    9
    9
    10
    8
    9
    9
    9
    9
    9
    9
    9
    7
    8
    This is my total in B18 - 20
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    You appear to be asking an Excel question. This is an Access newsgroup, not
    an Excel newsgroup. Please post your question in an Excel newsgroup.

    --
    Rick B



    "brian" <brian@discussions.microsoft.com> wrote in message
    news:05EDDA13-682F-4486-8F15-5EFF89D7D3D1@microsoft.com...
    >I have the following numbers in the B2:B17 (b2 thru B17 cells) and when I
    > highlight the B2:17 cells to add I get a total of 20 (I have d\formatted
    > the
    > cells as numbers and also tried gerenal) but will not total correctly any
    > suggestions?
    > 9
    > 9
    > 11
    > 9
    > 9
    > 10
    > 8
    > 9
    > 9
    > 9
    > 9
    > 9
    > 9
    > 9
    > 7
    > 8
    > This is my total in B18 - 20
    >
     

Share This Page