I'm trying to create a spreadsheet that will generate an assignment
for my students on the use of "BEDMAS" - order of operations.  I plan
to print it out and give it to them, and that part is working fine.  I
am having trouble getting Excel to take the data and calculate it.  I

I have a field in Excel containing numbers. When I import to Access, the data
is lost. Other numeric fields in the same worksheet are imported just fine.
This happens both with Access 97 and with Access 2003, and it doesn't matter
if I save the Excel file to tabbed-text or DBF. ...

cell AN1009 formula
=IF(AO1009>=AM1009,"RETURNS OVERDUE","RETURNS RECIEVED")
I need to expand this where if AO1009 is < AM 1009 "Returns revieved
but late" appears in AN1009.

I want to sum cell D4 across a range of sheets.
I've got the first and last sheet names:
   Hello my name is Gilbert      (in cell C1)
   I like squirrels                     (in cell C2

I am doing a text to columns function using fixed width. Once this is done,
it drops any preceding zeros. Any ideas how to stop dropping the zeros?

I am trying to do a calculation outside of a pivot table using pivot table
data. The problem is that if I reference data inside the table the cell
references the calculation as through I was using an absolute cell reference
when I want a relative cell reference.  How can I turn ...

I have a workbook with about 7 tabs.  I need to insert a line with data in a
number of places in each tab.  Is there a way I can do that (sort of a find
and replace)?  To do it the hard way, I have inserted a line, copy and pasted
the line that I need to insert.  It takes a while ...

I have a worksheet with an array of data similar to (but much bigger
than) the example below
Type    Size    Value
1    10ct    1

I inherited a worksheet where first and last name are combined in one cell
(i.e. Jane Doe)  The first name is listed first.  Can I sort this this by the
LAST name?  How?  If not, how can I split the text into two cells FIRST NAME
and LAST NAME?

How do I assign a value to an item in a drop-down list i n Excel? I need a
value to an item, such as "weekly", "monthly", etc., that will be used to
calculate other data in other cells.

I have been looking for a way extracting some data from an excel
spreadsheet and have been told pivot tables are the way to do this.
However the 'count' option which appears at the end of each group is
adding up the totals rather than counting the number of instances. For

I would like help with a formula for the following:
If A1 is more than 5 working days greater than B1 = 'Failed'
If A1 is equal to or less than 5 working days greater than B1 = 'Passed'
Many thanks.

Sumif allows you to add numbers in a column IF another cell in the same row
meets a certain criteria.
Question:  Can I do this calculation if I have two sets of criteria instead
of just one?

Looks like this
Adam        1
Smith         2
Johns         6

Excel is pausing for a very long time during copy/paste. It takes 10+ seconds
to copy a single cell (text only), and another 10+ to paste. It is as if
Excel (or another program) is performing another task in between. Thoughts?