Jonathan -
First, thank you for your assistance. After some cussing (and once again
thinking accountants work sheets are easier except for all the adding),
I have at least some of it working as I want it to.
First, though I prowled through all the configuration areas I could
">Format >Stylist >Cell Styles >Font"
-----
Found nothing about fonts under "Cell Styles" but I did eventually find
a spot that I .think. worked. Trouble is, one stumbles across these
things then can never find them again.
However, I am using 1.1.4, not the 2.0 beta. New software and I don't
get along - I hate feeling so stupid - so I preferred the stable version.
> In "C2", you simply type (sans quote marks) "= d2+e2+f2+g2+h2+i2"
-----
Ah - start with an equal sign. Maybe I'll try "= d2:i2". Nahh, it's in
there and working. If it ain't broke, don't fix it.
Then, how do I copy that formula to rows 3, 4, etc.?
Copy c2 (or the entire row) and then past on c3, on down.
----
Either this was easy or I was lucky. Worked first time.
I also want to add columns and copy that formula to columns C, D, etc.
"=sum (c1:c3200) will total up everything in column c.
-----
.That's. what I was looking for! Single colon in the middle.
"CTRL F12 >cell Styles >Numbering" and change it to currency.
-----
Well, I really didn't want all the dollar signs showing and if it will
automatically insert the decimal point, I haven't found that. So far, I
have to put all the decimals in myself which really slows me down - I
can run a 10-key by touch but not when I have to hit the decimal point.
Is there a section of the help file that covers really simple, basic
information?
Yes, but you have to know the exact term, to find what you re looking
for, which doesn't help anybody when they don't' know what the term
used to describe what they want done is.
------
Reminds me of when I was an ADC/Food Stamp caseworker.
Applicant has a bank account. For how to handle them, check the index under:
a) savings account
b) bank account
c) checking account
d) credit union account
e) savings and loan accounts
f) none of the above
F, of course. Look under "assets". (Which is why my manual's index was
covered with post-its.)
I checked "help" under "adding" which referred me to "sum" ("sum", to
me, means add, not any other operation but I'll worry about that later)
which states: "Automatically adds the number in the cell range you
specify." Sure would be nice if it gave some examples. <primevil scream>
At the moment, I'm entering expenses from credit card statements so
there are sometimes several in a category. I tried 2161+4403 hoping it
would put the total in the cell. It didn't, nor, as mentioned did it
insert an appropriate decimal point. So I'll pull my 10-key calculator
out. (And in the middle of that sentence, I found myself typing in the
spreadsheet!?! How'd .that. happen?)
Thank you again.
Carolyn Stoffel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
