Is there a worksheet function that could help finding out whether
theres a number in a cell, within a string etc??
Thanks.
Elaine.

I am using a formula to calculate service level percentage.  The answer
displays as 1082% and should be 82%
Thanks for the help,

I have a Pivot Table that shows blank cells but does not calculate the number
of cells.  There are 3 records with blanks.
                      No                   262
                      Yes                       2

I have a spreadsheet that has employees with pay grades,  SR01 all the way
through SR15. I have a vlookup that looks for this in my paygrade range that
has SR01 next column the amt.  (=vlookup,b2,paygrade,2).
The problem, I have some top officials listed, but with a pay grade not ...

Dear Sir,
I have 3 terminal servers (1,2 and 3) with MS Outlook 2002 in my workplace.
All of them are running on MS Window 2000 (Proffesional) OS.
Recently, I found that I was not able to open the Excel file from a few

I have four sheets of the same document on one worksheet. I have written a
basic formula that counts the sheets that have data in them and returns a
number 1 thru 4. I have also named four ranges 1 thru 4 to reflect sheets
1&2, / 1,2,& 3, /etc.

I am using Excel 2003 and I wish to draw a quadrant which will have coloured
regions in it. Any simple and quick way of achieving this?

Previously both project explorer and the code window (is that the correct
word) were docked together. If I added a new module this too would 'dock' to
the project explorer.
I don't recall changing anything but now if I add a new module the window

Is there any way that I could set the default display format for "currency"
data type to a pure figure (without the "$" symbol in the front)?
I am exporting data from access to excel. Those "currency" data type figures
are displayed with a "$" symbol in excel. Even if I change the ...

I have a workbook that many users use.  A create a template and place it in
a central location on a network drive.  It has macros.
Periodically I need to revise or create new macros and currently that
creates a problem because I need to acess each of the workbooks created by

I have 2 files from a customer that I need to merge into one file.  
File 1 has typical columns (ID #, Last name, First Name, Address, City, St
etc)
File 2 has only 2 columns (ID # and Hosp. Aff. Code)

If I have 2 sheets both with a list of unique identifiers on it, what is the
best way to run a query which will check to see if I have all the IDs in one
that are in the other:
i.e.

Well, I just found a workbook which i had put in protected mode with a
password long back,
Now i want to edit the workbook but, i have forgotton my password.
Is there any way of going around this password.

Hi all I’m new to excel and was wondering if someone would be kind enough to
help me out.
The main worksheet consists of all the data, example: name and totals, I was
wondering if it’s possible when I create a new worksheet that it would list

There is a list of number under column A, and there is another list of number
under column B, which is refered to the value in column A, such as
3 [A1]  =A1 [B1]
6 [A2]  =A2 [B2]