|
|
|
How to get a certain cursor shape
Sat, 5 Jul 2008 15:55:15 -0400
Hi all, Excel 2007
I was trying to go through the steps of summarizing table data, and part of
the instructions said "move the pointer over the upper-left corner of the
column header until it becomes an arrow that is at about at a 5:00 angle.
Then click once to select the table's data range, and again to se ...
|
skins on spreadsheet for a tournament
Sat, 5 Jul 2008 11:55:00 -0700
What formula can I use to get less than par on a hole to be a colored text? ...
|
Remove quotation marks
Sat, 5 Jul 2008 08:51:00 -0700
Is there a way to remove quotation marks from an Excel spreadsheet?
My file has looks like this:
"000151","001","SCREW-5/16-18 X 5/8 HEX CAP","A1"
"000922","001","SCREW-10-32X1/4 RHM-ZP"
But everything I try it I either get it to import but I loose the leading
00's (zero's) or it looks like this.
"000 ...
|
Copy a Worksheet problem
Sat, 5 Jul 2008 08:31:20 -0700 (PDT)
Hi.
I am trying to copy a worksheet by using CTRL and drag.
When I click on the tab I am getting a 'stop' symbol (circle with a
diagonal line through it).
I have used this procedure many times before. What has changed?
What can I do?
Thanks,
Dave Moore ...
|
watch priyamani glamors photo
Sat, 5 Jul 2008 05:27:35 -0700 (PDT)
watch priyamani glamors photo
from movie clips
*****************************************
http://priyamaniforyou.blogspot.com/
***************************************** ...
|
Time Question
Sat, 05 Jul 2008 00:15:22 -0700
Column D: 11:01 PM
Column E: 11:10 PM
Using this formula =IF(C116="","",IF(D116="",0,D116-C116)) I get in
column C: 0:09 (Elapsed minutes, which is what I want.)
All well and good until this happens
D: 11:01 pm
E: 12:03 am
Not I get gobbledeegook.
...
|
PV, Annuity, Lump Sum
Fri, 4 Jul 2008 17:18:33 -0700 (PDT)
I am looking at John Walkenbach's Excel 2007 Formulas. On page 302, he
has the result of a formula that I think is an error. I am not
confident enough to be sure. In fact, my answer doesn't look right.
The formula is based on the following scenario:
Your brother-in-law wants you to invest in his carpet cleanin ...
|
|
|
Excel 2007 crashes upon changing the properties of a data connection
Fri, 4 Jul 2008 08:58:35 -0700 (PDT)
Hi there,
I'm using a Dutch Excel 2007 (SP1) with a spreadsheet that has a few
tabs with text file (CSV) based data queries.
When I go to the properties of one of the data connections, uncheck
the "Prompt for filename upon refresh" and uncheck the "Auto refresh
upon spreadsheet load" Excel crashes 10 out of 1 ...
|
Result of formula not displayed (rather the formula itself is
displayed)
Fri, 4 Jul 2008 07:57:02 -0700 (PDT)
Hopefully a rather straightforward question, but I just don't seem to
find an easy fix:
I have an XLS where some cells will not display the result of a
formula, but rather the formula as such.
On other words: if the contents of the cells would be:
cell A2: 3
cell A5: 7
if I enter =A2+A5 in another cell, I w ...
|
Percent Within Target
Fri, 4 Jul 2008 06:30:01 -0700
I need help creating a formula that will calculate the percentage of values
that are <= 14 (days).
Sample data:
29,34,96,15,14,14,13,13,13,13,13,13,12,12,11,11,10,9,9
Thank you.
Christine
...
|
|
|
