I am trying to save xls to a xslm and get this message. "This workbook
contains excel 4.0 and excel 5.0 macros. If you would like to password
protect / restrict permission these macros need to be removed" I have gone
into the macros listed for this workbook and deleted them.. It ...

L1 = Hours worked per day
G:G = Total time in hours
L2 = Completion date
How would you write this formula to return a completion date?

I need to put a column letter in a cell (i.e. n), and then have the
formula refer to it as part of a cell reference.
More specifically, on the end of this formula, you will see n38 -
=IF($L38=OFFSET(AV38,-1,0),IF($C38=0," Amount?",$C38*N38),0)

I have a workbook with 4 sheets that is pretty well set...I have to add one
or two columns to one sheet for some important additional functions...?..do
I have to also rewrite or modify a macro I have to format the sheet...or
will the macro "update" as a result of the column ...

I guess I misunderstand how RANK works...
The following is pasted across row C11:IV10
"=IF(C10=0,"",COUNT($C$10:$IV$10)-(RANK(C10,$C$10:$IV$10)+COUNTIF($C$10:C10,C10)-1)+1)"
Value in BO10 and CD10 are the same (201) which is the highest in that row...

I have downloaded the above form and customised it following the instructions.
I have one question that I hope someone can answer.
Is there any way (macro, vba code, anything) I can disable the New/Insert
button.  I only want to use this form for editing existing records.

I have 3 columns that have data of which column A has the criteria I want to
search for.  Once found, I want to select columns A, B, and C that match the
search criteria ( in this case "7760").  
The code below allows me to find the criteria and select columns A, B, and C

In Excell 2007, everytime you save a file, a backup file is auto created.  
How do you stop this?

Problem
Can anyone provide me with a formula to calculate 6% per year on an amount
of currency (14,000), for a period determine between two dates inclusive.
My Thoughts

I have a row entry in a column that extends beyond the column's right border.
How can I increase the width of the column?
Thank you.

Please help, I need to execute a complex MAX and LOOKUP.
I have a worksheet set up like this:
col D      col E     col F             col G
Mike      1          10/1/2007     10/23/2007

I an looking at a SUMIF formula that includes the & symbol. See below. What
does the & symbol do?
=SUMIF($AN$6:$AY$6,"<="&$D$5,AN8:AY8)

I received a spreadsheet with the address already pre-formatted for a label
but I need to parse that data into individual fields.  The pre-formatted data
has a next line/carriage return at the end of each line.  How do I do a parse
when the delimiter is several carriage returns ...

can you PLEASE indicate me  where i can find an example of a spreadsheet where
i can see an example of CHOOSE function in all its forms and variations ??
eg : CHOOSE((B9="X")+2*(C9="Y")+1, "neither", 5, 6,"both")

Please tell me if this is possible:
I need to create a customer database that can be continually updated with
new information.  With that information, I would like to be able to access a
particular customer on another worksheet form.