Prev: Styles
Next: "This is a pre-release version of the Compatibility Pack and c
From: db on 30 Apr 2010 13:05
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(a)gmail.com> wrote in message
news:7f85dbf6-088f-4b0b-81a2-61c73b312eaf(a)z30g2000yqz.googlegroups.com...
> 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.

First  |  Prev  | 
Pages: 1 2
Prev: Styles
Next: "This is a pre-release version of the Compatibility Pack and c