Thanks you Stephen and Tom. This worked perfectly, the line above the
average was the total for the column and I had used the "autosum" icon
which when you left one of the lines blank it gave you the #VALUE
warning, once I change it from the autosum to a formula then the
entire spreadsheet
All
I¹m looking at my stock spreadsheet. All the black numbers have turned to
red.
What formula do I use to turn the RED numbers back to BLACK?
Tom
___
The next Louisville Computer Society meeting will
be January 27 at MacAuthority, 128 Breckinridge La
there's a question that will have me on pins and needles until I hear
your answers! Sandy
On Dec 5, 2008, at 9:30 AM, Tom Guenthner wrote:
All
I’m looking at my stock spreadsheet. All the black numbers have
turned to red.
What formula do I use to turn the RED numbers back to BLACK?
Tom
_
Tom --
If you are referring to negative numbers, you need to highlight the affected
area of the spreadsheet, go to Format>Cells>Number and then either highlight
number, currrency, or accounting. You can then set your preference as to
how negative numbers are handled.
If the problem is with all n
What to do: when I try to open any of my appleworks documents, I get
"You can not open this document because it may be damaged or
incomplete". What on earth have I done, and can I fix it?
Help! These are appraisals I am working on, and must get
finished!Sandy
On Dec 5, 2008, a
Tom:You can only use the formula once every four years, and the date has just past. Here is what they are saying now. NealOn Dec 45, 1120082007, at 9:30 AM, Tom Guenthner wrote: All I’m looking at my stock spreadsheet. All the black numbers have turned to red. What formula do I use to turn the
Sandra,
While I appreciate your need for an answer to your question your
usergroup etiquette is lacking.
You posed your question in response to someone else's question.
When you want to ask a question you need to start a new email with a new
subject.
Just so I'm clear, you say when you try to
Oh, Harry, why not posing another question when you don't know the
answer anyhow? What etiquette are we talking about? Would you mind
making a list and checking it twice and then send it to us etiquette
user morons. I did not know we should not add another question to one
just asked? I do i
Marta,
Enlarging the scope of someone's question with a similar question one
thing. Changing the topic altogether is another.
Sandra's question about corrupt appleworks files has nothing to do with
the original excel question.
If I am following the thread of the excel question I look to answers
I won't make the same mistake twice. Actually, I thought the
question about excel was a jokesince all my stocks are in the red
column, too. (I still think it was meant so, but I guess "Tom" is
the only one who can answer that question) S (ps thanks, Marta)
On Dec 5, 2008, at 2:18
Let's lighten up. I though it was a joke too. And not only that, the
statement made a good joke.
That's why I joined in. At my age, you have to start enjoying life a
little.
Neal
On Dec 45, 1120082007, at 2:41 PM, Sandra Schreiber wrote:
I won't make the same mistake twice. Actually, I
Thanks, Neal, I had hoped I would lighten it up, too. At my age I am
"washed with all waters," "mit allen Wassern gewaschen" as we in
German would say. But when I read Harry's answer, being dead serious
--- I simply could not believe it. And to think I devilishly enjoy my
moronic state in
³A merry heart does good, like medicine...² Proverbs 17:22.
___
The next Louisville Computer Society meeting will
be January 27 at MacAuthority, 128 Breckinridge Lane.
Posting address: MacGroup@erdos.math.louisville.edu
Information: http://www.math.lo
Amen John, and Tom had me laughing so hard about his stocks now
appearing in red, and wanting to know the formula for getting them
back to black.we all can relate to that!!
John
On Dec 5, 2008, at 3:50 PM, john humphries wrote:
“A merry heart does good, like medicine...” Proverbs 17:2
I have replaced my laptop computer and am either going to sell it (so
I can buy a iPod Touch) or give it to my nephew who has a much more
powerful computer but no laptop (for all I know he might turn around
and sell it). Here is the best description I can give for it.
If interested contact m
For the record, the original question had nothing to do with stocks, and was
clearly not a joke.
Steve
___
The next Louisville Computer Society meeting will
be January 27 at MacAuthority, 128 Breckinridge Lane.
Posting address: MacGroup@erdos.math.louis
WE all know that -- that's why it was a joke! I am signing off on
this one now, but it was wonderful while it lasted-
But here is a REAL questions: How, in my leopard, can I show the 24
hour time in the iCal week's set-up in the first column to the left.
In my Tiger it is a cinch, but some
17 matches
Mail list logo