When I enter a hyphen (-) into a cell, them move out of the cell it
immediately tries to start entering a formula or function.  As soon as I move
out with the arrow buttons, each cell I move to keeps the dashed/dotted
border.  Selecting a cell and pressing the enter key creates a ...

Is there any way I can score a list of 10 numbers from 1 - 10?
IE:
52
44

I have a worksheet (A) with a list of employee names in one column and
their rates of pay in another column.
On another worksheet (B) within the workbook, I have a list of hours
that employees worked, that includes a list of employee names in one

I have a formula created and as a result of the functions it must go
through it may return #VALUE. How can I get it to show nothing instead
of #VALUE?
E21==IF(ISNA(HLOOKUP(A21,Sheet1!A155:G157,3,TRUE)),"",HLOOKUP(A21,Sheet1!A155:G157,3,TRUE))

I have a spreadsheet that I would like to export into crystal reports.  Can
you help me?

Need piece of advice.
I have to get the last number from the row that is more than 0. Sounds
a little complicated but actually it is for example:
CEll A1 -  10

Using Excel 2003 I have a worksheet where some of the cells are bolded text
and the rest are un-bolded text.  The text in every un-bolded cell needs to
be deleted but there's so many that it takes a very long time to do it
manually.  Is there a way to automate this process?

This sounds awfully basic, but for the life of me, I can't figure out
how to do it.
I would like the date at the top of my spreadsheet to reflect the last
save date for the file. Isn't there a function that will handle this?

Dear all - I'm not familiar with accounting jargon but what I need is this:  
say I have a range of different numbers from cell A2 to cell A100.  I need to
establish if any of these cells *ADDED TOGETHER* equal "x".  so when I enter
the no "x" into the formula in cell A102, this ...

I am trying to extract characters to the left of position 3 in a variable
length character string.
Examples:  12548698; 124586; 111478566
In the above I want to get the following 12548; 124; 111478

Is there a way to Sort a Spreadsheet by Color? I have an enormous spreadsheet
with yellow highlights scattered through and I want to sort by the
Highlighted rows.
How do I do this?

days    perdiem    total
1    50    50
2    50    100
3    50    125

Hi,
When I enter the formula which is at the end, I get the result of 3 in Col
B, row 2 instead of 2.
Category    New    Term

Hi.Can anybody help me to solve this problem with hlookup function?
I have a worksheet with students' midterm grade.The instructor woul
like to see what would be the impact of using a Progressive Curve o
the Midterm grade.

I am trying to print specific data in an Excel spreadsheet to 1/3 cut folder
labels. Is there a way to do that other than manually moving the necessary
data to a cell the size of the label?