i have a column of numbers that range from -5000 up to 150,000 and would like
to place the numbers into perspective from 0% to 100% but i can't figure it
out , can someone help.

I have selected some rows and in those rows I have data.
Rows goes all the way to the end of the sheet.  Is there anyway I could
select only cells with data in them.
thx.

I was trying to copy an example from excel help(I typed in nper function into
the search box) into a worksheet and was getting a value error.  Why was I
getting this and how can I make it so I do not have the value error?
Here is what I was trying to copy:

I've created a form that has ended up being 12 pages long.  
I want to use a command button or object button or something so the user can
move from one section to another by selecting one of the button choices.
For example, I just completed the "demographic" section and the next ...

I am working on a large workbook with many worksheets.  The main worksheet
that i have is where i enter all my info on. The heading for the columns are
the months of the year.  on the rows are the dollar amounts. The dollar
amounts I have them flowing into my summary sheets. ...

I have an Excel worksheet that I have fit the columns to a column width of 2.
I copy every cell from this worksheet into a new worksheet that I have set
the column widths to 2 also.  However, when I paste the cells into the new
worksheet, the column width of the new worksheet is ...

I want to do a cell validation on a worksheet that would come from a table of
Yes or No. I colored the cells in the list to have a Green backround with the
word Yes in the cell and a Red backround with the word No.
My question is there a way for the colors to show up in the cell ...

I am trying to create a spread sheet and need to enter 0023408 and it wants
to put 23408. I need the 00 to be there. How can I turn this feature on or
off.

I have this code to display a real-time clock on a worksheet. However if I do
anything else with in the workbook or worksheet such as type in a cell i get
an error message "application defined or error defined error". How do I get
rid of this problem?

Here is my sumif presently: =SUM(IF(C5:C1000>=20%, IF(C5:C1000<30%,1,0))).
What I would like is to add column B to it as well where it looks for a
particular Supervisor and then add together the amount of people between 20
and 29.99%. This is what I would like to add: B5 ...

Can someone help me with a formula? I 'm using a dropdown menu in one cell,
in the other cell I need the answer. The dropdown list cell has a y for yes,
n for no.
The other cell where the answer will go needs to show if i pick N from

All of a sudden accessing file in my hard drive from any of the Microsoft
Office 2003 Service Pack 3 is almost impossible as it takes a long time. It
seems that something is frozen. I have tried using other software to access
the hard drive and it seems to work fine. I used to ...

Spread sheet 1 shows entire inventory data base and includes:
Item Description # column (ie 0001)
Item Description column (ie Widget)
Quantity on-hand column (ie 12)

1st post so please be gentle!
I am after a formula that works in the same way as a Sumif.
I am trying to count particular data for a certian week. However thi
data is in more than 1 column!

I have a column named PTS Number
I have used the custom validation to ensure that duplicate values are not
repeated.
Is there a way of combining the COUNTIF formula to ensure that at least 6