+ Reply to Thread
Results 1 to 3 of 3

why does excel return a : when I put in a .

  1. #1
    Jose
    Guest

    why does excel return a : when I put in a .

    Does anyone know why when I enter =SUM(A1.A22)
    Excel 2003 automatically changes the formula to =SUM(A1:A22)

    I would be grateful for feedback

    Thanks

  2. #2
    Chip Pearson
    Guest

    Re: why does excel return a : when I put in a .

    The proper syntax is to use a colon, not a period. I think Excel
    automatically corrects this for you -- the period syntax, I
    believe, comes out of Lotus 123.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Jose" <[email protected]> wrote in message
    news:[email protected]...
    > Does anyone know why when I enter =SUM(A1.A22)
    > Excel 2003 automatically changes the formula to =SUM(A1:A22)
    >
    > I would be grateful for feedback
    >
    > Thanks




  3. #3
    Gord Dibben
    Guest

    Re: why does excel return a : when I put in a .

    Why would you put a decimal point(period) in the formula?

    Excel does not recognize that as a valid entry so assumes you mean A1:A22

    Maybe you meant =SUM(A1,A22)


    Gord Dibben MS Excel MVP

    On Fri, 14 Jul 2006 11:15:01 -0700, Jose <[email protected]> wrote:

    >Does anyone know why when I enter =SUM(A1.A22)
    >Excel 2003 automatically changes the formula to =SUM(A1:A22)
    >
    >I would be grateful for feedback
    >
    >Thanks



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1