I have created a drop down list!  The problem I am having is that sometimes I
want to be able to type free form in the cell rather than using the drop
down.  Can I do this?  If yes, how do I do it?

I am using Excel 2000 and if I enter a formula that uses the / key to
perform a divide function, I get a "formula you typed contains an error"
message. This will happen with basic =4/5 or with cell references.
If I open an existing sheet that has a divide function, it will work ...

I need to count the number of times a person, who's name is in column A, has
a specific value,"0", in column B, where the worksheet contains an
ever-increasing amount of records (rows).  Is there an easy way to make this
happen?  Any help is appreciated.  Thanks

I am using excel for preparing a schedule of Doors. For sorting the data i
have used the following formul
SUM(IF(D2:D2263=1,IF($H$1:$H$2263=E2269,IF($K$1:$K$2263=G2269,IF($E$1:$E$2263="A",$C$2:$C$2263,0),0),0),0))
which returns a #Value Error.

I have two worksheets, one is named Db and the other Info. Info is basically
an easy to read record summary and this summary comes from each record in
Db. I have a unique number assigned (a record number) for each record on the
Db sheet and is located in Column A. I will enter that ...

I need help converting data from text to number in order to export into
Access.  The current format is as follows:
1234-0000012345-6 and need to have it as 12340000123456
I looked into other postings but could not find a solution...then again I

I an using the TEXT function because I want to show a number in a cell
without that number being picked up in SUM functions on the worksheet.  I
want the text to display with a dollar sign on the far left of the cell, with
a space for parentheses, and the number on the far right. ...

I have a spreadsheet and need to peform checks to makes sure all of th
data is enetered correctly then I want the output to be a cell whic
dislpays red, amber or green depending on the status.
These are the conditions I need,

I need to highlight which cells contain a formual with having to look at each
cell (approx, 6,000+ cells to be analyzed within 6 individual tabs, in one
worksheet)
Is there a quick way to do this?  I prefer to have something like:  If the

I would like to make the row color turn red based on the follow condition:
If the value in column P (all rows) is less than the value in column Y then
I want to change the color of the row to Red.  
I know this is in condiitional formating but I cannot get it to work.  I am

I have data being imported to a spreadsheet that needs to be sorted.
The range of data elements is inconsistent.
I want to automate the sort function.
I recorded a macro that highlights the first data element, which will always

I am trying to create a schedule of values for work.  On this schedule
I want to track hours used in three columns: 1) past used, 2) curren
usage, and 3) total used.  Past will olny be calculated when a ne
number is inputed into "Current Usage."  So, for example, in the firs

I have few cells which have comments in a worksheet A linked to a worksheet
B. However, worksheet B displays only data from worksheet A and not comments.
How should I link comment also?
Thanks for your help!

I have a pivot table that displays results as follows:
St Louis        warehouse
                   plant
Pittsburg        warehouse

I am trying to put "CS&T Monthly Totals" in the Custom Header. But it
keeps changing it to CS&[Time]. I have tried everything I can think of,
short of spelling out the acronym. I have put it in as "CS & T" and it
then it shows CS T ? Confused. Any suggestion would be appreciated!