In cell J14 I have the formula =AVERAGE(H14:I14).
When nothing is in the cells H14, I14 I have the message #DIV/0, and since
the colomn width is small I see the ### signs.
How do I need to modify the formula in cell J14 so that nothing is seen

Can anyone please help.
We have installed Office 2007 on some of our machines for evaluation, but wish
to continue using compatabilty mode (i.e. Office 2003) as documents are
regularly sent outside of the organisation for editing and return. These are

I have the following VBA code with opens a Word Template (.dot extension)
from Excel:
1.  CommandButton1 code on worksheet --
Private Sub CommandButton1_Click()

I have a daysheet that automatically enters the date in cell D1 as
value(Today()). Now I would like to be able to automatically save the
sheet as the date in the form 01-24-07.

I have a multi-tab budget worksheet. I run XLS03, no macro.
Now, after opening the file, when I enter a number in a cell in one of the
tab, the number appears on the other tabs at exactely the same cell
location. It happens on 4 tabs out of 8 in total. It's like all 4 tabs are

I am not able to do this formula without help.
I need a formula that checks if the cell O15 has the letter Y. If yes, it
should give as a result 25% of the value in cell F15 (or multiply F15 by
25/100). If no, it should give as a results the value in cell F15 (100%).

In Excel 2002 if you had lots of groups of rows in a sheet.
When you expanded/shrunk them, it would be done immediately.
Moving to Excel 2003, this process was slowed down.  Almost to a crawl.
The thought around my office here, was it was done on purpose.

Is there a way in excel to turn off the hyperlink feature for an entire
column of data?  I have a column of email addresses, and I don't want any of
them to be an active hyperlink.  I can remove the hyperlink individually,
but have not been able to find a way to do it for the ...

This seems fairly simple but I'm not sure how to achieve it.
Using Excel I have to simply print a sequential number on the top right of a
number of pages. When that page #1 is printed that sequential number will
increment to #2, page 2 is printed, etc

I know only enough about Excel to get me in trouble so please keep your
answers as basic as possible.
I have a entry like  01/04/2006 10 23 42 48 54 03 x4
when I paste this into a worksheet I would like it to appear like this

Going down the worksheet there could be 50 instances of Hong Kong, 50
instances of Jakarta etc in col B. For each port there is weekly data of
volume transported and the volumes is what makes up the data by port by
mth/yr by supplier. A brief example of the spreadsheet is shown.

how many rows does excel have? please let me no if u no...thx a bunch!
x
--
aly

I have a row of dates, one week apart and I use the conditional format to
highlight the current week. I would like to highlight the column 12 cells
below the current  date which contain text . I tried numerous things ,but my
knowledge is limited.

This might be an easy one but it has been bugging me for hours already.
I have a workbook (seri.xls)  with 6 worksheets namely:
Frontpage,Input,PartsData,LookupLists,PivotTable,MsiaChart.
I have created two links from my website which will open the respective

I have a quite a large array formula:
{=(INDEX('[Plant Movements Entry.xls]Data'!$E$2:$E$9997,MAX(('[Plant
Movements Entry.xls]Data'!$A$2:$A$9997=A3)*ROW('[Plant Movements
Entry.xls]Data'!$A$2:$A$9997))-CELL("row",'[Plant Movements