I need to import a file greater than 65536 lines. I have read and tried
Microsofts macro on this (http://support.microsoft.com/kb/120596/en-us) but I
need the file to be in a Fixed Width format and not the Delimited format the
above macro provided.

I am trying to put together a checkbook registry much like the Excel
Checkbook Registry Template, and I know how to make the columns/ rows a
certain function (i.e. currency, date, etc.) but I can't figure out the
formula to get the running balance.  If someone could help, i would ...

I have a workbook with two worksheets in it
worksheet A contains (starting in row 2)
A - Product ID
B - Part Number

The basis of this formula is to work out room size and depending on the area
allocate a suitable sized air conditioning unit ....
In cells  D7 to D10  I will have a figure between 0-45 (sq metres)
In cells E7-E10 I require an answer based on D cells

Can somebody help me out on this.
I have a sheet with formulae from multiple work sheets, how can i
update the sheet without opening the other sheets.
Thanks for your help on this.

I'm using the Now() function as a timestamp in a cell. The trouble is that
each time the sheet opens up, the timestampt is changeing to the current
date. How can i implement a timestamp without this to happen?
Thanks a lot in advance..

This is probably easy one but I cant figure it out.
I want to get the field name/label from the same row in the column to the
left of the result of a MAX or LARGE function. Tried LOOKUP but data is not
in order.

I remember in algebra or one of the classes I took long ago that I can see
how many times a number could go into another number by using the div,
opposite of mod.  What function will let me do that in excel?  I don't see a
div function.

I am sending out an Excel 2003 workbook questionnaire to travelers.  They
will complete it and email it back to me.  What is an easy way to compile all
of the information from the multiple workbooks into one master workbook?

I'm trying to track manfacturing productivity between day and swing shifts.  
I was hoping there was a function that would give the current date and time
WHEN a cell = x which will designate a task is complete.  I've got a list of
tasks that are performed and as I mark them off as ...

I am trying to input Degrees/minutes/seconds in the one cell.
I have setup a custom format thus:
[h]°:mm':ss''
However, when I type in 017°30'20'' I get 4152480°:00':00''

I am trying to measure a service efficiency .  
Cell C4, requested amount.  
Cell D4, received amount.  
Cell E4 =C4/D4. with result in%  

I think this is more of a question about present value concepts and how
to formulate a financial problem than it is about how to use the Excel
functions.  The question was sparked by someone else's inquiry.
Suppose I build something and sell it.  It costs me $2000 to build it,

how do i solve for interest rate earned when i know:
number of months,
amount of each payment,
amount of my original investment?

I need to find the standard deviation of the Males of different age
groups and the STDEV function does not allow me to specify that only
the males of a certain age group in my data should be included in the
calculation.  If anyone can tell me how to do this or what function to