Hi Friends!
Could some help me on this formula?
I need to complete a task say from 1-Jun-05 to 30-Jun-05 i.e 30 days,
but however on a given day when I analyse the Project schedule (say

I have a group of rows and want to transpose them  to a columns.
say I have  column of address  
(four rows,
Address,

I am in excel and I have the following formula  = Q:26 typed into Cell
C:2.  What I want to do is have a second cell D:2 that takes what ever
cell reference I enter into C:2 and adds 1 row to it.  So cell D:2
would be equal to Q:27, which is 1 row down from row Q:26.  Is there a

How do I create an IF statement to calculate the following:
Between a series of dates, IF there is a 3 day or more lapse, I want to
count 1.  IF there is less than 3 days, do not count anything
Thanks,

I have a group of account numbers that I need to search for everytime I
open a certain worksheet. I would like it to automatically search for
the account numbers listed then highlight it in yellow to alert me.
I hope somebody can help me, bec. it's a pain doing the ctrl F

Currently, I am working on an application that opens an Excel spreadsheets
and populates it with data. However, I have been unable to find any
documentation on how to change the data type in a Cell or range. I would
like to change a cell from "General" to "Percentage" data type ...

I am a new Excel user.  My husband has a drop-down menu next to his AutoSum
that allows access to Sum, Average, count, Min and Max.  I don't have access
to that menu.  Is that about the version I am running or can I add it?

How do I make the formula show in the formula bar and keep it there?

Any tips on performing this?  Im having great difficulty in having th
table column and row sizes transfer from word to excel.  It stretche
the table out into an unusable format.
Thanks

I went to the worksheet in question, right clicked and copied to another
excel file.  I then removed all the old excel file name references.  The
cells are still linked to the old excel.

Is there a way to use part of the worksheet name within a header or footer?
This is what I want to do.
I have a worksheet named "May 2005".
I want to put "Invoice Date:  5/31/2005" within the header with other

.Each month I have several forms to complete and send into
head office.These forms are saved as word docs but I can't
type any new imformation in them.In stead I have to print them
off and then fill them in by hand. I am a new user of Office but

When I open my file in excel it continues to say running virus scan for hours
and overnite.  How do I stop this so I can use this file?

Hello... I hope that someone can help me.
I have a worksheet for which I randomly enter scores for students in
several categories throughout the day.
Column Headings:

I have never built any macros before so I did a little reading on how to do
it. Im trying to combine a date cell with a time cell, I can get the macro to
work but it only copies the cell that the macro was created on to every other
cell. I use the relative reference button but it ...