First off, thank you all for your assistance with this question.
I am making a database and in a cell I am using the validation list option
for the following selections:
SAT, UNSAT, N/A

I am writing a website. I have a link that opens an Excell spreadsheet. I
need the user to be able to enter some data and click a button field with a
hyperlink that will email the entire worksheet to me

I am sure this is pretty simple, but I can't seem to figure it out. I have
this number that I want to convert in years, months, days format. What
formula to use to get the munber 505 converted to that. It is not the
difference between two dates, so I can't use datedif.

When using excel, I use rounded $#'s and need it to total as such. Example:
$2.35 rounds to $2.
$2.35 rounds to $2.=$4 excel totals =$5 do to the .35+.35=.70 rounding up to
$5

Is it possible to concatener by formula several columns into one ?
Example: initial data
A1: A3 = {1, 2, 3}
B1: B3 = {4, 5, 6}

My employer sends out report forms which we are to complete. Because he was
bullet points, etc. we have been told to create the docs in Word, then import
them into the workshhet. The problem I have is that although the entire
contents of the doc appear in the formula, when I ...

Is there a way to check the time in two cells to make sure that it doesn't count a lunch break. ie
Start time is 8:45 end time is 16:25 so I need to subtract 30 minutes, however if I run an if statement
and say use >12:30 if the job starts after 12:30 it will still subtract 30 ...

Hi all.  I have a workbook that contains over hundred rows.  Each row has a
colour indicating what worksheet it relates to.  In a column at the end of
the worksheet I would like to add a number that represents that colour so I
can then filter by number (tried filtering by color ...

Does anyone know a method of calling/running a macro from within a cell
function (e.g. a logical IF function)? I am currently using XP Office with
Excel 2002.

When i paste a single cell to a merged cell. This err
display. How can i resolve it.
Thanks in advance

I want to create a summary worksheet that shows the data in the same cells on
all the other worksheets in the workbook.
I have 30 individual worksheets, one for each employee in the department,
detailing overtime absence etc for the month.  On sheet 1 I want to create a

I have been playing around with the countif statements and am trying to
figure out a few forumlas which I can not see to code:
Arguments:
Checking the cells c6:f6 if any of the cells have the words "Missing"

I've got the following Data on sheet 1
person, group
john,A
tiger,B

The shading and patterns added to my worksheet do not appear on the
worksheet.  They do appear in the view mode.  How can I have patterns
displayed on the worksheet itself?