excel 2003 problem

[tony vella]

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.

 

[db]

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]

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

~~~~~~~~~~~~~~~

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.

 

[db]

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]

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

~~~~~~~~~~~~~~~

On the way. Thank you.

 

[db]

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

~~~~~~~~~~~~~~~