Here is a snip from an e-mail from one of my clients...
Our nurses have an excel folder that has one file for every resident.  Each
file for each resident is updated one time a month.  It is 728kb in size.
The files have quite a few check boxes.  The files are on our network drive.

I am trying to enter cell phone usage minutes:seconds in Excel 2003
therefore, the minutes can be 4 or 5 digits (i.e. 12345:03).  I have used a
custom format of [m]:ss.  I have found I must enter the information as
0:xxxxx:xx.  It shows in the formula bar as a date and time but ...

Is there a way to join two points on a line chart/scatter graph
despite a gap in the data? I have several samples that were each
tested at different time points and I would like to join the data from
each time point together despite the existence of 'empty' time points.

One of our Financial analyst is using VLOOKUP formula using 2-3
different workbooks. Formula on workbook 1 is
=IF(AsofDate_Match_YN,VLOOKUP(I$471,'\\server1\Performance Data\
[Summary Reports.xls]Summary1'!$A$1:$AZ$10,4,FALSE),NA())*100

I want to calculate weeks based on days. Days are in column H, weeks should
come in column I, a so far empty column. I don't know the amount of rows in
H (days). I put in a macro Worksheets("sheet1").Activate,
ActiveCell.CurrentRegion.Select, because if want for each activated

I have two work-sheets.
On the first are the employees work percentages
from 01.01.01    to 02.01.06   100% (39 h/week)    Patrik
from 03.01.06    to 01.01.07     80% (31,2 h/week) Patrik

I have a list of 'imported' blood test data that look like this;
Name    DoB    SampleID    TestName    TestResult
A, A      1/1/01 123456        X                 1
A, A      1/1/01 123456        Y                 2

I am cant get this to work, I need a formula  so cell A1 will show 1 if cell
A2 is A, 2 if B and 3 if C
thanks to all

I want to achieve the following effect:
When some worksheet is protected. the user could only select the
locked cells. but he could do anything he want in the unlocked
cells.

in excel i am not able to see worksheet menu bar. in customize menu is not
highlighted while right click at the blank space

I have an Excel spreadsheet containing several addresses, I need to export
to a "Contact" folder in Outlook; my problem is that, after choosing the
destination file, I get the following error message:
The Microsoft Excel 97-2003 file

I have made a query, that gets the parameter from my cell A11. There
is always only one result, which is written i cell B11.
Now i wish to copy that formula from A11 to the area A12:A3000, so it
picks up the parameter from the row, where the formula is placed. The

I need a spreadsheet that will help keep track of my electrical usage. I
have made the following and I would like it to do 2 things: In the total
column, I would like it to automatically put in the numbers of the 5 dial
fields and then when I add a row every day, have it ...

I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in ...

Is it possible to place a button in a spreadsheet that will undo all the
changes that have been made since the spreadsheet was opened?
Thanks,
Clem.