What button do I hit when I am supposed to do Accounting 2 autoformat

I need to be able to create an "if" function that will populate to a couple
other "if" functions within itself.
What I'm trying to do is get one cell to look at the information entered in
another one, and if that cell gets to a certain number, to change the

I am upgrading to XL 2007 from 97 and having a problem which sounds
simple but is annoying as hell.  I have as many as 150 XL files open
at one time (all linked to one another)  and with office 97 I would
exit XL and then be prompted to either  save the files one at a time

Folks,
I'm struggling to resolve this Execl formula.
I've got a workbook with 2 sheets: Summary and Source Data. The workbook is
used a template so that data exported from another system can be copied and

Ok. I need to have a formula which would look at a number of columns
and tell me now many 'consecutive' months someone has been in the top
33% of the numbers in that column to date. IE . . .Ann was in the top
33% in Jan and Feb but not in March so in March I would want the

I have conditional formatting already set to shade a row differently for 3
conditions.  But I also need to have a date cell's value change to red if
it's manually changed.
I'm wondering if there's a way to use Excel's custom number format feature

Using XP and Office 2003
I created a pivot table to analyze a group of email address extensions.
(".com" or ".org" or ".gov", etc.)
The pivot table returned the count of each extension type and the grand

I have made an invoice in sheet1 and have list of items in sheet2.
How can I make a dropdown list in invoice showing sheet2 items and at the
same time get the unit price for the item too?
i.e.

I have a spreadsheet that I'm using to track progress over the period
of a year. One sheet is raw data that is manually entered daily and
one sheet is monthly statistics based on that data. In the statistics
worksheet are cell formulas calculating statistics relating to each

I have a spreadsheet which will be used by individuals to update an
Access database.  The columns are locked, but I do allow them to hide
columns to make the data more customized.  Periodically they will
refresh their data from the database.  In order to avoid forcing them

Almost without fail, while working on a lengthy worksheet my excel crashes.

I am using the following formula to extract month from the date:
=month(a1)
The result is 1
What I wan to see is Jan instead of 1.

The problem is that I need some help in Excel.
Let me explain:
Here is an example:
If we say that a cell like C5=7 and we need A7,

Using Excel 2007, how do you create a pivot table using multiple ranges?
The option does not appear in the Create Pivot Table wizard.
I thought I could use something like this: 'Page 1'!$A$6:$T$28805:'Page
2'!$A$6:$T$28805 ; but it wasn't accepted as a valid range.

I'm new to doing Database Queries in Excel but I'm having a case
sensitive problem.  I have the same install and I'm working with the
same files as my coworkers but when we each perform the exact same
steps my results are case sensitive and theirs are not.  This is what