|
|
|
|
2 |
328 |
|
|
clock by
Alun Davies
Is there a working clock that I can have on an excel
worksheet? I need to input data on the hour every hour
from a running total. This would make it easier if...
|
October 8th, 2003 01:08 PM
by Ecco
|
2 |
366 |
|
|
Coloring cells by
Troy
What I am looking for is if B7 is 19 then color the
following cells in gray A7, B7, C7, D7, E7, F7, G7, and H7.
How can I get this accomplished.
|
October 8th, 2003 01:22 PM
by Paul
|
1 |
140 |
|
|
Multiple worksheets by
DB
Hello,
I am working with order forms for different types of
equipment, each having its own worksheet. After selecting
the appropriate sheet, I then want the...
|
October 8th, 2003 02:54 PM
by DB
|
0 |
133 |
|
|
|
|
0 |
141 |
|
|
Text in Excel by
Amanda
I am trying to switch the order of words in a cell. For
example I would like to switch "John Doe" to "Doe, John"
in the cell next to the original. Is there...
|
October 8th, 2003 03:23 PM
by Dan E
|
1 |
124 |
|
|
|
|
1 |
252 |
|
|
|
|
3 |
188 |
|
|
parse by
Raman
I have a formula in one cell =e5+0.125
(The second part of the formula is hard coded)
I need to separate it out to =e5 in one cell and 0.125 in
another. What...
|
|
1 |
96 |
|
|
COUNTIF by
Pinda
I have a table with 2 columns, 1 column contains either G,
A, or Rs in them, and the other column has names.
I have a formula that counts all the Gs, As and...
|
October 8th, 2003 04:37 PM
by Pinda
|
4 |
129 |
|
|
Automatic Invoice Number by
Vicki Pempek
I am creating an invoice and would like to know if there
is a way to have the worksheet create a new invoice
number each time the document is...
|
October 8th, 2003 04:41 PM
by Paul B
|
1 |
452 |
|
|
Problems with "Rate" function by
Stuart Crofts
I have a simple loan that I want to calculate the interest=20
rate for.
6 months ago I owed say =A38,000. I've paid =A3100 per month,=20
Now I owe say...
|
|
2 |
228 |
|
|
displaying all the text data in a cell? by
mari
hi-
i've been diddling around with format and wrap and i
still cannot solve this problem.
My worksheet has 2 columns in it/100 rows.
i have one column with...
|
|
1 |
410 |
|
|
Macro substitution by
Catalin
Hi to all and one.
I have the following problem: I can find the row number
by some formulas and I know the column. Is any "macro
substitution" to use them for...
|
|
1 |
115 |
|
|
Excel Matrix by
Harrison Tigrett
Hi,
New to Excel and trying to figure out how to create a
formula with constant and changing variables. I am trying
to create a matrix where I do the...
|
October 8th, 2003 06:17 PM
by Dan E
|
3 |
165 |
|
|
Calculating End of Quarter Date by
Jeanne
I have a column of dates and I need to add a column that
rounds the dates to the end of the quarter in which they
occur. Quarters are standard -- J-F-M,...
|
October 8th, 2003 06:22 PM
by Jeanne
|
2 |
264 |
|
|
text to numbers by
Rita
Ihave a field that was put in as text. example 1.795 I
want to change it to number. When I go to format to
number, it tells me it is a number but when I go to...
|
|
3 |
91 |
|
|
how to express as a ratio? by
yao
I'm trying to figure out how to express two data series
as a ratio, (e.g. 14:1) rather than as a fraction. Any
ideas?
Cheers,
yao
|
October 8th, 2003 07:28 PM
by Dave R.
|
3 |
158 |
|
|
Help a.s.a.p. PLEASE! by
Peggy
I can only get the worksheet I was working on to appear
when I go to print preview. There I have no problem
zooming the sheet in or out. However, when I go...
|
|
2 |
123 |
|
|
formulas using time by
Ron
I am trying to return results based on the time of day
entered into a cell.
here is an example of where I am at...
|
|
1 |
157 |