1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

excel 2003 problem

Discussion in 'Microsoft Office' started by tony vella, Apr 28, 2010.

  1. tony vella

    tony vella Flightless Bird

    66 years old.

    I have been asked to record daily my weight and blood-sugar count. I
    am using Excel 2003 on a Vista machine. I am trying to compare monthly
    averages between doctor visits.

    I have both columns formatted as 'number'
    (select column>format>cells>number, 2dp)
    yet when I try to sum or average the numbers, the formula only
    includes the most recent 3 cells. And, when formatting, it does not
    add the 1 or 2 decimal zeros to most of the numbers in the columns. I
    have selected the entire spreadsheet and made sure the protection
    "lock" is not selected.

    I hope I explain myself well enough for someone to help - I am
    certainly no whiz at this. Thanks in advance for all help.

    Tony Vella
    Ottawa, Ontario, Canada.
     
  2. db

    db Flightless Bird

    as an example of how I
    would do this:

    you can put the dates
    beginning with cell
    a3 through a365

    in cell a2 type the
    word date

    in cell b2 type the
    word weight

    in cell c2 type the
    word sugar count

    now go to the top row
    and enter the formulas

    so in b1 you can
    enter something
    like =average(b3:b365)

    then copy the formula
    to cell c1

    then block / highlight
    the cells in b1 and c1
    for 2 decimal points

    format row 2 with bold
    and or background colors.

    then block cells b3 to c365
    with two decimals.

    and block/highlight a2 to
    a365 with the date format.

    the above is simply one
    many examples of creating
    a spreadsheet.

    you can also click on
    f1 for help and enter
    in the search for something
    like "average" to get a
    better idea of that formula.


    --
    db·´¯`·...¸><)))º>
    DatabaseBen, Retired Professional
    - Systems Analyst
    - Database Developer
    - Accountancy
    - Veteran of the Armed Forces
    - @Hotmail.com
    - nntp Postologist
    ~ "share the nirvana" - dbZen

    ~~~~~~~~~~~~~~~
    >
    >


    "tony vella" <ajay.vella@gmail.com> wrote in message
    news:ad147612-7c9b-4761-85fc-17a26a24c627@11g2000yqr.googlegroups.com...
    > 66 years old.
    >
    > I have been asked to record daily my weight and blood-sugar count. I
    > am using Excel 2003 on a Vista machine. I am trying to compare monthly
    > averages between doctor visits.
    >
    > I have both columns formatted as 'number'
    > (select column>format>cells>number, 2dp)
    > yet when I try to sum or average the numbers, the formula only
    > includes the most recent 3 cells. And, when formatting, it does not
    > add the 1 or 2 decimal zeros to most of the numbers in the columns. I
    > have selected the entire spreadsheet and made sure the protection
    > "lock" is not selected.
    >
    > I hope I explain myself well enough for someone to help - I am
    > certainly no whiz at this. Thanks in advance for all help.
    >
    > Tony Vella
    > Ottawa, Ontario, Canada.
     
  3. tony vella

    tony vella Flightless Bird

    On Apr 28, 2:26 pm, "db" <database...@hotmail.com> wrote:
    > as an example of how I
    > would do this:
    >
    > you can put the dates
    > beginning with cell
    > a3 through a365
    >
    > in cell a2 type the
    > word date
    >
    > in cell b2 type the
    > word weight
    >
    > in cell c2 type the
    > word sugar count
    >
    > now go to the top row
    > and enter the formulas
    >
    > so in b1 you can
    > enter something
    > like =average(b3:b365)
    >
    > then copy the formula
    > to cell c1
    >
    > then block / highlight
    > the cells in b1 and c1
    > for 2 decimal points
    >
    > format row 2 with bold
    > and or background colors.
    >
    > then block cells b3 to c365
    > with two decimals.
    >
    > and block/highlight a2 to
    > a365 with the date format.
    >
    > the above is simply one
    > many examples of creating
    > a spreadsheet.
    >
    > you can also click on
    > f1 for help and enter
    > in the search for something
    > like "average" to get a
    > better idea of that formula.
    >
    > --
    > db·´¯`·...¸><)))º>
    > DatabaseBen, Retired Professional
    >  - Systems Analyst
    >  - Database Developer
    >  - Accountancy
    >  - Veteran of the Armed Forces
    > -  @Hotmail.com
    > -  nntp Postologist
    > ~ "share the nirvana" - dbZen
    >
    > ~~~~~~~~~~~~~~~
    >
    >
    >
    > "tony vella" <ajay.ve...@gmail.com> wrote in message
    >
    > news:ad147612-7c9b-4761-85fc-17a26a24c627@11g2000yqr.googlegroups.com...
    >
    >
    >
    > > 66 years old.

    >
    > > I have been asked to record daily my weight and blood-sugar count. I
    > > am using Excel 2003 on a Vista machine. I am trying to compare monthly
    > > averages between doctor visits.

    >
    > > I have both columns formatted as 'number'
    > > (select column>format>cells>number, 2dp)
    > > yet when I try to sum or average the numbers, the formula only
    > > includes the most recent 3 cells. And, when formatting, it does not
    > > add the 1 or 2 decimal zeros to most of the numbers in the columns. I
    > > have selected the entire spreadsheet and made sure the protection
    > > "lock" is not selected.

    >
    > > I hope I explain myself well enough for someone to help - I am
    > > certainly no whiz at this. Thanks in advance for all help.

    >
    > > Tony Vella
    > > Ottawa, Ontario, Canada.


    Hello DB, thanks for trying.

    I already have some 6 months of daily entries and I am trying to find
    a way of fixing my spreadsheet without having to input all the info
    into a new work page.

    Here's an example: I format an existing column as 'number' with 4
    decimal places. It automatically adds the necessary zeros to, maybe,
    a dozen cells - definitely not to the entire column of numbers. If I
    copy the cells from, say, A1:A245 and paste them into a new
    spreadsheet, format the column (on the new page) as number with 4
    decimal places, it does exactly the same thing: it only adds the extra
    zeros to no more than a dozen cells. I simply can't figure out a way
    out. It is so frustrating I wish I could send the file to someone
    (privately) who knows what's what. I mean, my weight and blood-sugar
    content is not exactly national security, you know.

    Tony Vella
    Ottawa, Ontario, Canada.
     
  4. db

    db Flightless Bird

    you can email it to me:

    databaseben at hotmail dot com

    --
    db·´¯`·...¸><)))º>
    DatabaseBen, Retired Professional
    - Systems Analyst
    - Database Developer
    - Accountancy
    - Veteran of the Armed Forces
    - @Hotmail.com
    - nntp Postologist
    ~ "share the nirvana" - dbZen

    ~~~~~~~~~~~~~~~
    >
    >


    "tony vella" <ajay.vella@gmail.com> wrote in message
    news:8d46717f-eb5a-4327-b4fc-038a90e04388@d39g2000yqa.googlegroups.com...
    > On Apr 28, 2:26 pm, "db" <database...@hotmail.com> wrote:
    >> as an example of how I
    >> would do this:
    >>
    >> you can put the dates
    >> beginning with cell
    >> a3 through a365
    >>
    >> in cell a2 type the
    >> word date
    >>
    >> in cell b2 type the
    >> word weight
    >>
    >> in cell c2 type the
    >> word sugar count
    >>
    >> now go to the top row
    >> and enter the formulas
    >>
    >> so in b1 you can
    >> enter something
    >> like =average(b3:b365)
    >>
    >> then copy the formula
    >> to cell c1
    >>
    >> then block / highlight
    >> the cells in b1 and c1
    >> for 2 decimal points
    >>
    >> format row 2 with bold
    >> and or background colors.
    >>
    >> then block cells b3 to c365
    >> with two decimals.
    >>
    >> and block/highlight a2 to
    >> a365 with the date format.
    >>
    >> the above is simply one
    >> many examples of creating
    >> a spreadsheet.
    >>
    >> you can also click on
    >> f1 for help and enter
    >> in the search for something
    >> like "average" to get a
    >> better idea of that formula.
    >>
    >> --
    >> db·´¯`·...¸><)))º>
    >> DatabaseBen, Retired Professional
    >> - Systems Analyst
    >> - Database Developer
    >> - Accountancy
    >> - Veteran of the Armed Forces
    >> - @Hotmail.com
    >> - nntp Postologist
    >> ~ "share the nirvana" - dbZen
    >>
    >> ~~~~~~~~~~~~~~~
    >>
    >>
    >>
    >> "tony vella" <ajay.ve...@gmail.com> wrote in message
    >>
    >> news:ad147612-7c9b-4761-85fc-17a26a24c627@11g2000yqr.googlegroups.com...
    >>
    >>
    >>
    >> > 66 years old.

    >>
    >> > I have been asked to record daily my weight and blood-sugar count. I
    >> > am using Excel 2003 on a Vista machine. I am trying to compare monthly
    >> > averages between doctor visits.

    >>
    >> > I have both columns formatted as 'number'
    >> > (select column>format>cells>number, 2dp)
    >> > yet when I try to sum or average the numbers, the formula only
    >> > includes the most recent 3 cells. And, when formatting, it does not
    >> > add the 1 or 2 decimal zeros to most of the numbers in the columns. I
    >> > have selected the entire spreadsheet and made sure the protection
    >> > "lock" is not selected.

    >>
    >> > I hope I explain myself well enough for someone to help - I am
    >> > certainly no whiz at this. Thanks in advance for all help.

    >>
    >> > Tony Vella
    >> > Ottawa, Ontario, Canada.

    >
    > Hello DB, thanks for trying.
    >
    > I already have some 6 months of daily entries and I am trying to find
    > a way of fixing my spreadsheet without having to input all the info
    > into a new work page.
    >
    > Here's an example: I format an existing column as 'number' with 4
    > decimal places. It automatically adds the necessary zeros to, maybe,
    > a dozen cells - definitely not to the entire column of numbers. If I
    > copy the cells from, say, A1:A245 and paste them into a new
    > spreadsheet, format the column (on the new page) as number with 4
    > decimal places, it does exactly the same thing: it only adds the extra
    > zeros to no more than a dozen cells. I simply can't figure out a way
    > out. It is so frustrating I wish I could send the file to someone
    > (privately) who knows what's what. I mean, my weight and blood-sugar
    > content is not exactly national security, you know.
    >
    > Tony Vella
    > Ottawa, Ontario, Canada.
     
  5. tony vella

    tony vella Flightless Bird

    On Apr 29, 9:04 am, "db" <database...@hotmail.com> wrote:
    > you can email it to me:
    >
    > databaseben at hotmail dot com
    >
    > --
    > db·´¯`·...¸><)))º>
    > DatabaseBen, Retired Professional
    >  - Systems Analyst
    >  - Database Developer
    >  - Accountancy
    >  - Veteran of the Armed Forces
    > -  @Hotmail.com
    > -  nntp Postologist
    > ~ "share the nirvana" - dbZen
    >
    > ~~~~~~~~~~~~~~~
    >
    >
    >
    > "tony vella" <ajay.ve...@gmail.com> wrote in message
    >
    > news:8d46717f-eb5a-4327-b4fc-038a90e04388@d39g2000yqa.googlegroups.com...
    >
    >
    >
    > > On Apr 28, 2:26 pm, "db" <database...@hotmail.com> wrote:
    > >> as an example of how I
    > >> would do this:

    >
    > >> you can put the dates
    > >> beginning with cell
    > >> a3 through a365

    >
    > >> in cell a2 type the
    > >> word date

    >
    > >> in cell b2 type the
    > >> word weight

    >
    > >> in cell c2 type the
    > >> word sugar count

    >
    > >> now go to the top row
    > >> and enter the formulas

    >
    > >> so in b1 you can
    > >> enter something
    > >> like =average(b3:b365)

    >
    > >> then copy the formula
    > >> to cell c1

    >
    > >> then block / highlight
    > >> the cells in b1 and c1
    > >> for 2 decimal points

    >
    > >> format row 2 with bold
    > >> and or background colors.

    >
    > >> then block cells b3 to c365
    > >> with two decimals.

    >
    > >> and block/highlight a2 to
    > >> a365 with the date format.

    >
    > >> the above is simply one
    > >> many examples of creating
    > >> a spreadsheet.

    >
    > >> you can also click on
    > >> f1 for help and enter
    > >> in the search for something
    > >> like "average" to get a
    > >> better idea of that formula.

    >
    > >> --
    > >> db·´¯`·...¸><)))º>
    > >> DatabaseBen, Retired Professional
    > >>  - Systems Analyst
    > >>  - Database Developer
    > >>  - Accountancy
    > >>  - Veteran of the Armed Forces
    > >> -  @Hotmail.com
    > >> -  nntp Postologist
    > >> ~ "share the nirvana" - dbZen

    >
    > >> ~~~~~~~~~~~~~~~

    >
    > >> "tony vella" <ajay.ve...@gmail.com> wrote in message

    >
    > >>news:ad147612-7c9b-4761-85fc-17a26a24c627@11g2000yqr.googlegroups.com....

    >
    > >> > 66 years old.

    >
    > >> > I have been asked to record daily my weight and blood-sugar count. I
    > >> > am using Excel 2003 on a Vista machine. I am trying to compare monthly
    > >> > averages between doctor visits.

    >
    > >> > I have both columns formatted as 'number'
    > >> > (select column>format>cells>number, 2dp)
    > >> > yet when I try to sum or average the numbers, the formula only
    > >> > includes the most recent 3 cells. And, when formatting, it does not
    > >> > add the 1 or 2 decimal zeros to most of the numbers in the columns. I
    > >> > have selected the entire spreadsheet and made sure the protection
    > >> > "lock" is not selected.

    >
    > >> > I hope I explain myself well enough for someone to help - I am
    > >> > certainly no whiz at this. Thanks in advance for all help.

    >
    > >> > Tony Vella
    > >> > Ottawa, Ontario, Canada.

    >
    > > Hello DB, thanks for trying.

    >
    > > I already have some 6 months of daily entries and I am trying to find
    > > a way of fixing my spreadsheet without having to input all the info
    > > into a new work page.

    >
    > > Here's an example:  I format an existing column as 'number' with 4
    > > decimal places.  It automatically adds the necessary zeros to, maybe,
    > > a dozen cells - definitely not to the entire column of numbers.  If I
    > > copy the cells from, say, A1:A245 and paste them into a new
    > > spreadsheet, format the column (on the new page) as number with 4
    > > decimal places, it does exactly the same thing: it only adds the extra
    > > zeros to no more than a dozen cells.  I simply can't figure out a way
    > > out. It is so frustrating I wish I could send the file to someone
    > > (privately) who knows what's what.  I mean, my weight and blood-sugar
    > > content is not exactly national security, you know.

    >
    > > Tony Vella
    > > Ottawa, Ontario, Canada.


    On the way. Thank you.
     
  6. db

    db Flightless Bird

    On the way back.

    You're welcome.

    --
    db·´¯`·...¸><)))º>
    DatabaseBen, Retired Professional
    - Systems Analyst
    - Database Developer
    - Accountancy
    - Veteran of the Armed Forces
    - @Hotmail.com
    - nntp Postologist
    ~ "share the nirvana" - dbZen

    ~~~~~~~~~~~~~~~
    >
    >


    "tony vella" <ajay.vella@gmail.com> wrote in message
    news:7f85dbf6-088f-4b0b-81a2-61c73b312eaf@z30g2000yqz.googlegroups.com...
    > On Apr 29, 9:04 am, "db" <database...@hotmail.com> wrote:
    >> you can email it to me:
    >>
    >> databaseben at hotmail dot com
    >>
    >> --
    >> db·´¯`·...¸><)))º>
    >> DatabaseBen, Retired Professional
    >> - Systems Analyst
    >> - Database Developer
    >> - Accountancy
    >> - Veteran of the Armed Forces
    >> - @Hotmail.com
    >> - nntp Postologist
    >> ~ "share the nirvana" - dbZen
    >>
    >> ~~~~~~~~~~~~~~~
    >>
    >>
    >>
    >> "tony vella" <ajay.ve...@gmail.com> wrote in message
    >>
    >> news:8d46717f-eb5a-4327-b4fc-038a90e04388@d39g2000yqa.googlegroups.com...
    >>
    >>
    >>
    >> > On Apr 28, 2:26 pm, "db" <database...@hotmail.com> wrote:
    >> >> as an example of how I
    >> >> would do this:

    >>
    >> >> you can put the dates
    >> >> beginning with cell
    >> >> a3 through a365

    >>
    >> >> in cell a2 type the
    >> >> word date

    >>
    >> >> in cell b2 type the
    >> >> word weight

    >>
    >> >> in cell c2 type the
    >> >> word sugar count

    >>
    >> >> now go to the top row
    >> >> and enter the formulas

    >>
    >> >> so in b1 you can
    >> >> enter something
    >> >> like =average(b3:b365)

    >>
    >> >> then copy the formula
    >> >> to cell c1

    >>
    >> >> then block / highlight
    >> >> the cells in b1 and c1
    >> >> for 2 decimal points

    >>
    >> >> format row 2 with bold
    >> >> and or background colors.

    >>
    >> >> then block cells b3 to c365
    >> >> with two decimals.

    >>
    >> >> and block/highlight a2 to
    >> >> a365 with the date format.

    >>
    >> >> the above is simply one
    >> >> many examples of creating
    >> >> a spreadsheet.

    >>
    >> >> you can also click on
    >> >> f1 for help and enter
    >> >> in the search for something
    >> >> like "average" to get a
    >> >> better idea of that formula.

    >>
    >> >> --
    >> >> db·´¯`·...¸><)))º>
    >> >> DatabaseBen, Retired Professional
    >> >> - Systems Analyst
    >> >> - Database Developer
    >> >> - Accountancy
    >> >> - Veteran of the Armed Forces
    >> >> - @Hotmail.com
    >> >> - nntp Postologist
    >> >> ~ "share the nirvana" - dbZen

    >>
    >> >> ~~~~~~~~~~~~~~~

    >>
    >> >> "tony vella" <ajay.ve...@gmail.com> wrote in message

    >>
    >> >>news:ad147612-7c9b-4761-85fc-17a26a24c627@11g2000yqr.googlegroups.com...

    >>
    >> >> > 66 years old.

    >>
    >> >> > I have been asked to record daily my weight and blood-sugar count. I
    >> >> > am using Excel 2003 on a Vista machine. I am trying to compare
    >> >> > monthly
    >> >> > averages between doctor visits.

    >>
    >> >> > I have both columns formatted as 'number'
    >> >> > (select column>format>cells>number, 2dp)
    >> >> > yet when I try to sum or average the numbers, the formula only
    >> >> > includes the most recent 3 cells. And, when formatting, it does not
    >> >> > add the 1 or 2 decimal zeros to most of the numbers in the columns.
    >> >> > I
    >> >> > have selected the entire spreadsheet and made sure the protection
    >> >> > "lock" is not selected.

    >>
    >> >> > I hope I explain myself well enough for someone to help - I am
    >> >> > certainly no whiz at this. Thanks in advance for all help.

    >>
    >> >> > Tony Vella
    >> >> > Ottawa, Ontario, Canada.

    >>
    >> > Hello DB, thanks for trying.

    >>
    >> > I already have some 6 months of daily entries and I am trying to find
    >> > a way of fixing my spreadsheet without having to input all the info
    >> > into a new work page.

    >>
    >> > Here's an example: I format an existing column as 'number' with 4
    >> > decimal places. It automatically adds the necessary zeros to, maybe,
    >> > a dozen cells - definitely not to the entire column of numbers. If I
    >> > copy the cells from, say, A1:A245 and paste them into a new
    >> > spreadsheet, format the column (on the new page) as number with 4
    >> > decimal places, it does exactly the same thing: it only adds the extra
    >> > zeros to no more than a dozen cells. I simply can't figure out a way
    >> > out. It is so frustrating I wish I could send the file to someone
    >> > (privately) who knows what's what. I mean, my weight and blood-sugar
    >> > content is not exactly national security, you know.

    >>
    >> > Tony Vella
    >> > Ottawa, Ontario, Canada.

    >
    > On the way. Thank you.
     

Share This Page