|
|
External References by
Pinda
When one has external references in a workbook, a dialogue
box pops up on opening the workbook saying...
"The workbook you opened contains automatic links...
|
|
1 |
166 |
|
|
|
November 10th, 2003 08:27 PM
by wendy
|
2 |
432 |
|
|
Tabs by
Michael
I'm using Excel 97 and I don't find the tabs on the bottom
of a spreadsheet that I opened. Are tabs used on this
version of Excel. If there are how can I...
|
|
2 |
89 |
|
|
Data by
OMer
Hi,
If I have the following Data, how can Excell help me
determine if the change in Today's value in Column C is
followed by tomorrow's value in Coulm B....
|
November 10th, 2003 08:50 PM
by Omer
|
2 |
107 |
|
|
excel form lines /and print command by
dan
I used excel workbook to make a calendar -all I added was
the month names in the cells on top. I hit file -print-
etc. when the copy came out of my Epson...
|
|
1 |
373 |
|
|
Find Wont Find Value by
Joe Gieder
When using the find feature (ctrl f) with a worksheet
that has nothing but formulas contained Find all of a
suden wont find the value, it's there because I...
|
|
1 |
742 |
|
|
=Rand() Help by
Steve Klenner
How can I create a formula that will allow me to generate a random 6 digit
number?
Thanks
|
November 10th, 2003 09:18 PM
by Dan E
|
1 |
133 |
|
|
How to convert text to numbers? by
T Bennett
I am importing a pile of numbers from Access to Excel. The problem is,
Access puts numbers in with the quote mark. If I copy a column then paste
special -...
|
|
1 |
280 |
|
|
Credit Card Number Suppression by
Dana
I have an existing workbook that contains a confirmation
that gets faxed to customers to sign off approving credit
card charges. The credit card # is typed on...
|
|
7 |
591 |
|
|
|
|
1 |
234 |
|
|
Convert seconds to mm:ss by
Larry
I have a worksheet that shows avg. elapsed time in seconds
as a numerical value (ex. 507.84275 is 507 seconds). I
need to convert this to a mm:ss format...
|
|
2 |
330 |
|
|
Unpivot by
Rich C
Is there a way to take a pivot table and 'unpivot' it back
to a normal spreadsheet?
|
|
1 |
121 |
|
|
Excel/Percentage by
David
I have recently upgraded excel 97 to 2002 and have noticed
that when i formated cells for percentage it multiplies
what i put in by 100 to create the...
|
|
1 |
92 |
|
|
Date format in cell by
Raymond Reedy
I set the format for the cell to be a date in the form 11/22 (no year) =
and=20
enter 11/15. Excel changes it to 11/15/2003. I do not want the year....
|
|
1 |
156 |
|
|
Highest and lowest value from column by
DrB
I have a column of numbers including blanks where I want to put into another
cell the highest and into another cell the lowest (ignoring the blank or a
zero...
|
November 11th, 2003 01:39 AM
by DrB
|
2 |
149 |
|
|
"dated if" statement by
todd
IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)*
($E14/40)
Hi, I am working on a set of dated if statement that I
have copied from an old worksheet. ...
|
November 11th, 2003 01:50 AM
by WShelton
|
3 |
166 |
|
|
negative hour/min values by
emily
Is there a way in Excel I can enter hour/minute values as
negative and therefore perform calculations on these
figures? I am developing a timesheet which...
|
November 11th, 2003 03:44 AM
by emily
|
4 |
364 |
|
|
Coloring Subtotals by
Scott V
How can i automatically color subtotals? Keep in mind
that the subtotal rows will constantly be changing.
Scott
|
|
1 |
117 |
|
|
|
|
1 |
378 |
|
|
|
November 11th, 2003 01:58 PM
by Mahesh
|
0 |
220 |