I have a formula "=sum(a1:a4)" at cell a5, normally it will display a "0"
when cells a1 to a4 are all blank. How can I hide this "0"?
Thanks
Turk

We have attendance sheets for each of our employees.  On the sheet, we have
an area depicting how much vacation an employee has accrued.  As long as
someone has worked for an entire year prior to the beginning of the year,
they will receive 80 hours (2 weeks) of vacation.  So, ...

I have used the formula from Bob Philips (10th Sept 06) in my worksheet:
=AVERAGE(IF(ISNUMBER('eligible 2% - 1jan'!U3:U501),'eligible 2% -
1jan'!U3:U501)).
I have to get the average also per department, so I have to check whether it

My Excel spreadsheet has numbers in the column headings.  I can't find a way
to change them back to alpha characters.

I know how to do fixed decimals thru the tools option on the menu, but is
there a way for it to be worksheet specifi?  I don't want all my worksheet to
be fixed, just certain ones.  Can anyone help?

I have a SS that I need to sum dollars and then delete the rows with the sum
numbers.  Is there a way to make a formula a constant?

I've got a column of cells with a date and time separated
by a single space.  I'm trying to delete the time.
The format is as follows
23-Apr-2006 20:00:00, This is stored as a text field.

I need to use a formula that will do the following:
Note:  All entries are given numbers in compiling a survey.  The following
cells can be any combination of "1".
A1=1 or A1=0

I have a list which I update regularly and need it to be kept in a certain
order.  But everytime I go to sort it I have to choose all the same options
again (no header, sort by column D, column B, column A).
Is there any way to set all these options so I can just press a button and

I have a colum of data almost 2500 entries long, what I want Excel to do is
take each cell and multiply it by a given value and then display it in a
corresponding cell
for instance:

How can i check for repetition of cell contents in a row/column? Please let
me know if a formula needs to be used for this or is there an already inbuilt
provision for checking this functionality? If there is a formula or steps to
be followed, please narrate the same.

I have been trying to format colum A to show dates of financial transactions.
I would like to be able to do this in the traditional way of mm/dd/yy.  Any
help anyone could offer me would be greatly appreciated.  I was ok on
previous versions of Excell, but frankly, I am lost on ...

I want to reference a cell in another worksheet. The name of the worksheet
however changes each month and is stored in another cell.
Can I link to a cell in the second worksheet by referencing the name stored
in a cell in the first one?

I have two spreadsheets with approx 30 columns of data.  They are not
identical   I am trying to create a 3rd spreadsheet  which will validate if
the mapped data was done correctly.  I thought I would have to copy a column
of data from the 1st sheet into the 3rd sheet, then do a ...

I am not very good at complex formulas and need to figure out a way to
calculate date intervals, say 6 months before a certain date and 2 weeks
before that date, etc.
Example:  Start with Oct. 9, 2006 in one cell.  Now I need to calculate 6