Prev: Styles
Next: "This is a pre-release version of the Compatibility Pack and c
From: tony vella on 28 Apr 2010 10:17
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.
From: db on 28 Apr 2010 14:26
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(a)gmail.com> wrote in message
news:ad147612-7c9b-4761-85fc-17a26a24c627(a)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.

From: tony vella on 28 Apr 2010 19:54
On Apr 28, 2:26 pm, "db" <database...(a)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...(a)gmail.com> wrote in message
>
> news:ad147612-7c9b-4761-85fc-17a26a24c627(a)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.
From: db on 29 Apr 2010 09:04
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(a)gmail.com> wrote in message
news:8d46717f-eb5a-4327-b4fc-038a90e04388(a)d39g2000yqa.googlegroups.com...
> On Apr 28, 2:26 pm, "db" <database...(a)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...(a)gmail.com> wrote in message
>>
>> news:ad147612-7c9b-4761-85fc-17a26a24c627(a)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.

From: tony vella on 29 Apr 2010 09:26
On Apr 29, 9:04 am, "db" <database...(a)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...(a)gmail.com> wrote in message
>
> news:8d46717f-eb5a-4327-b4fc-038a90e04388(a)d39g2000yqa.googlegroups.com...
>
>
>
> > On Apr 28, 2:26 pm, "db" <database...(a)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...(a)gmail.com> wrote in message
>
> >>news:ad147612-7c9b-4761-85fc-17a26a24c627(a)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.
 |  Next  |  Last
Pages: 1 2
Prev: Styles
Next: "This is a pre-release version of the Compatibility Pack and c