In my spreedsheet we have to record daily test results with an id numbered
assigned to them. To start the new year we would start with 20061. 2006
represents the year and 1 represents the first sample. I start the year with
this number and then in the following cells my formula ...

I am having trouble putting formulas into a cell.  I copy a formula into a
cell and then the cell I copied it froms formatting changes the moment I
press return to leave the cell.  It shows the formula not the result.  This
happens in both the cell I copied from and paste into.  ...

I am new to excel formulas I am trying to count two criteria each is in
a different column I found this formula in Excel help but it keeps
giving me !Value instead of a number any help would be greatly
appreciated

I just downloaded a format from microsoft online and on the top  of the
columns (like the header<name> cell) there is a button that you can click
that opens a bix that allows you to sort. I know how to do it just by the
tools menu, but how do you actually enter that button into a ...

I have a field with a bunch of numbers from 1 to 1000.  They need to be
displayed as 0001, 0002...0999, 1000.  I was looking for a function or number
formatting way of accomplishing this.

I am not sure whether it is possible or not. I will try to explain my
situation.
There are 10 guys in the team and we have 10 sheets created in a work book
and all are of same standard format. I have named the sheets with name of the

I needed a formula (that I was able to find on this group, btw).  The formula
from the gropu was:
=sumproduct(--(B2:B10=1),--(F2:F10="Completed"))
My question is, what does the -- do, and can I find more information about

I have created a macro, which in a nut shell, creates a new workbook,
and copies 3 worksheets (all in the same workbook) to the new workbook.
(See below for the macro)  I am creating, saving to, and copying from
an Excel file which is on our shared network drive here at work.

I am trying to develop a spreadsheet to schedule production batches. With some help from the group I have been able to get cells to predict completion times based on a start time and duration.
My current problem is that the duration time is a value calculated from the average ...

I have 2 questions in regards to VLOOKUP.  
1 - Is it possible to retrain the format of the cell which you are pulling
the value of?  For example text color
2 - In some of the original cells, the Alt+Enter key was used to perform a

Let's say I've created column A(# DAYS BETWEEN ASSIGNED & DUE DATE) and B (#
DAYS BETWEEN TODAY & DUE DATE)  Column C calculates number of days between
today's date and Due Date.  Column D uses info in Column C to calculate what
percentage of completion the deliverable should be ...

   In one of my spreadsheets I have a sumproduct formula that looks down a
column of dates and returns 7 day totals for certain items. Works great. The
formula is, in part:
=sumproduct(((meter readings!a$4:$a$1064>p$4).........

I have a big workbook with many worksheets, and many formulae in it.
The problem (which occurs whether I have automatic calculation on, or
manual) is that since certain formulas work off other formulas, one of
them is updated before the other, and then the result of one of them is

I have a question. I formula that generates a string result that I
would like to do some formating with. I would like to bold the text and
change the text color. But I do not want to do it to the whole cell.
Just a portion of the text.

I have an interesting problem-one that is confusing me and my collegues.
I have a workbook with 2 sheets.
One Sheet 1 I have a row of data, first column is data, next column is
more data pertaining to the first column.