I have some text that consist of uppercase and lowercase letters. But
excel keeps automatically changing this to propercase (first letter
uppercase, subsequent letters lowercase):
For example: IEb changes to Ieb

I need someone to help with excel sheets and I do not have much
experience with it.
I have two workbooks: 1. Workbook 1 and 2. Workbook 2
Both of these workbooks contain the same no of EXCEL sheets which is

I am working on a 10 column Excel (Mac OS X 2004) spreadsheet originally
created by someone else. I need to  add new data while retaining the original
info. When I attempt to add a new row across all of the columns, a thin, grey
frame/window appears around a section of the ...

Seeing all the Excel experts out here is giving me hope to solve this.
I am trying to find the 10 lowest (and if possible highlight them) of 20
numbers in a column and enter the results in the next column to the right.
There will be 6 columns total and 20 rows.

I'm using this formula, which is mostly working for what I need.
=VLOOKUP(B57,'data'!B$3:E$52,1,FALSE)
Basically, if it finds what's in B57 on the data!b3:E52 table, it's
producing the name match, which is what I need. However, if there's no match,

I have a column, say A, that I want to SUM(). I want to avoid including A1:A3
in this sum - unfortunately, the length of the data in the column at any time
is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although
that seems intuitive to me.

I'm working in Excel 2007.
I have two columns of dates, the first being a "buy" date and the second
being a "sell" date for the item in that row. If the data is valid, obviously
each date in the second column should be later than the corresponding date in

I'm working in Excel 2007.
I've got a column of dates, and I need to check the column as a whole to
ensure that every date is prior to today's date.
E.g. if today's date is 10/19/2007, and my column is the following:

Hello;
I am doing a simple function. I can't believe I have been trying to get this
to work for two hours. I know it's probably something stupid, so here goes.
=VLOOKUP(C3,ProductList,10,FALSE)

This is strange...
I have a spreadsheet of name, address, city, state, zip etc., etc.  I can
sort the list by the "last name" column (which is the 1st column) fine using
the "Data Sort" drop down box (there is a header row).  But for some reason,

How can I calculate the amount of money needed and the amount of time in
months to pay off a credit card, it I know the balance, the percentage rate
(compound interest) and the monthly minimum payment (2 to 3% of the unpaid
balance)?

Cell entry 100 shows as 0.01.  What to do?

I have a large amount of data, it's simply dates.
example
4/4/92
1/3/2007

I would like a box to pop up saying  NEW RECORD.
In column F if the cell is the minimun number then say NEW RECORD
For example F1 has 200
                  F2 has 199

I want a "macro button" that acts on one row to be able to be copied in many
other rows(1200), without having to write a new macro for each row. (to
Copy-Paste it and have it act the same as an EXCEL formula, changing the
relative addresses automatically).