=IF(DU86=0,"","Balance for the Month Ending:")
or
Conditional Formatting > =DU86=0 > White color Font
Does Conditional Formatting copy to anther excel?

I like to know how we can count the number of digits in a whole number...e.g. 243593 should return with 6...and so on
Also how can we now seperate this digits so they can be arranged like one per cell in the same sequence
In the above case how can I seperate the number so that A2=2 ...

XL2K.
I have a file which had list validation in one cell. The list was on the
same sheet, a few columns across. I've cleared the validation, but the
dropdown is still visible (although it doesn't actually do anything).

will like to ask for help on excel scenario pivot table. I try to use
the data from another spreadsheet and using the tools->scenario to
create the scenario pivot table. But when i tried to refresh the data ,
the 'refresh data' is disabled and i'm not too sure why. Any idea??

I have imported information into a worksheet. It contains
5 columns. I would like a way to filter out duplicate
entries using the first 3 columns as the comparison. The
database contains over 10000 entries with a large number

I have a column of data thus
         A
1      12345
2

Hello, I was wondering how can I make Excel 2003 stop
chaning value everytime I enter the formula =RAND() or
=RANDBETWEEN() in another cell.  For example, I put =RAND
() in cell A1, the number came out as 0.1.  Then when I

I am getting an error that says I am missing a parenthesis on th
following formula
=SUMIF((AND('Prime Sales'!A:A>=01/01/01,'Prim
Sales'!A:A<=01/31/03,'Prime Sales'!C:C)

hi folk,
i've a small network of 3 pcs. i wonder if is it possible
that the 3 pcs users may use a common excel sheet online?
what i mean is that when user01 edit cellA1 in sheet1 of

I recently installed installed ms office 2003 at work...
My excel program looks nice but my "equals button"
disappeared and is now replaced with the functions button
(Fx)

How do you copy the COUNTIF formula when you want to count
various items and still keep the cell range the same?  
Everytime I cut and paste the formula, it changes the cell
range (example - b2:t45 changes to b3:t46).  How do I make

How do you keep the COUNTIF formula from changing the
range of cells, when you copy and paste it to count
another item?  (example:  b2:t45 changes to b3:t46).

Sorry if this is very basic, but could someone please tell
me how to move the cursor, at the end of a recorded macro
to the first empty cell in a column (in this case C)
Thanks, Gary

Is there a way to add dates in Excel?  For example if I
have a cell with a date in it, can I have another cell
that takes that date value and adds 2 days to it? If so,
how?  Thanks!

Is it possible to insert a company logo as a watermark
where cells with content will appear on top of the
watermark?  Thanks.