|
|
formatting negative numbers by
GeraldM
Is there a way to format negative numbers in red WITHOUT fixing the decimal
precision.
i.e. if a cell is formatted as "general" then the number 1 displays as...
|
October 29th, 2009 11:17 PM
by GeraldM
|
0 |
125 |
|
|
|
|
5 |
121 |
|
|
drop down list by
Linda
When prompted to select from the drop down list, it starts at the very
bottom. You then have to scroll up to get to the top of the list. How do I
change...
|
|
3 |
127 |
|
|
separate strings by
cz1
Hey all,
The following is in one cell and I need a way to extract just the numbers so that I can put text to column the numbers. For example, my end goal is...
|
|
2 |
175 |
|
|
|
|
4 |
118 |
|
|
|
|
5 |
118 |
|
|
Excel 2003 is Better than Newest Ones!? by
Mike
Hi everyone,
I found Excel 2003 is more friendly than Excel newest version!
Location of many funtions of newest version are no longer easy to
find. For...
|
|
7 |
149 |
|
|
|
October 29th, 2009 09:43 PM
by jbclem
|
0 |
143 |
|
|
Formula to decrease value of cell by
Flyboy
Need to be able to have cell B4 decrease by 1 every 30 days until it reaches 0
I would also like to be able to take values in A17 move up one if A16 is
empty.
|
|
1 |
107 |
|
|
How to update multiple worksheets? by
Sunil Pradhan
I have identical MS Excel worksheets stored in different drives. I want to
update them all when i update my master copy? Any way out?
|
|
2 |
124 |
|
|
pivot table help by
Mike
I have a pivot table that toggles markets and products with metrics as row
labels and weeks as column labels. I would like the dates to be sorted from...
|
|
1 |
107 |
|
|
Comparing results of two formulas by
KimW
how do I compare the actual results of two formulas? Example: P1 has a
formula =edate(z1,10) and AF3 has a formula =edate(ac3,8). Want to compare
the results...
|
October 29th, 2009 08:48 PM
by Mike H
|
2 |
103 |
|
|
Excel formula by
Doug
I'm trying to calculate a net total by taking a number times 40% and then
deduct that percentage from the number to get the net total.
How do I create this...
|
|
4 |
97 |
|
|
Numbering rows by
nbslarson
How can I number rows but omit any hidden rows from the numbering sequence?
|
October 29th, 2009 08:38 PM
by AL
|
6 |
110 |
|
|
Format Painter won't stay on by
Lynn
I double click the format painter & use it once & then it shuts off. How can
I get it to stay on til I turn it off?
--
- L Fox PMP
|
|
5 |
110 |
|
|
|
|
1 |
111 |
|
|
Log Sheet by
Shane
I am trying to create a sheet that tracks the items entered into a certain
cell, or group of cells. What is the simplest code to accomplish this?
Ex:
I...
|
|
1 |
97 |
|
|
Macro that isn't working by
Brad
Should be really simple, but I'm missing something basic.
In the Cell.Replace (I want to replace the formula for the entire workbook)
&
If this can be...
|
October 29th, 2009 08:23 PM
by Brad
|
2 |
90 |
|
|
|
October 29th, 2009 08:20 PM
by Shane
|
3 |
101 |
|
|
SUMPRODUCT ERROR by
ColleenK
Hi There,
I am getting a value error when using the following formula:
=SUMPRODUCT(--('Detail Hours'!$F$1:$F$1000=D$3),--('Detail...
|
|
8 |
90 |