In Excel is there a way to have the file path print on all worksheets
created.  I would like to set it up to automatically insert the file path on
all documents.  I have done the header/footer set up but it only prints on
one page unless I set it up on each page separately.

I have two separates excel worksheets.
Worksheet no 1 which has two columns : A ( XP numbers) and B ( DO
numbers)
Worksheet no 2 which has several columns : A ( XP numbers) to O

is it possilble to extract integers from a text string within a cell?
Eg.
Cell A1 - "ABC 123"
I want to extract the "123" from cell A1.  

Excel Expert, please help  :)
may I know how I can retain number like
11.82 as 11
0.63 as 0

I have the following formula : =ROUND(D22/125*16,0)/16
How can I  round this formula up?
Using =ROUND(D22/125*4,0)/4 has rounded to 1/4 in crements, but it rounds
down not up.

I HAVE A ROW WITH ADDRESSES IN FORMAT
A
B
C

I have 2 workbooks, one contains inventory data (codes, item
descriptions, prices) and the other an invoice where I want to place
drop down Code bar in rows.  I would like to select an item code in the
invoice and the description and price automatically come up, derived

Good Afternoon,
This must be really simple although I seem to be hitting a blank, which
is really confusing me.
I have a bill template that is set to work out VAT etc... At the bottom

How would I go about summing a range that has the occasional Error in that
range?
Appreciatively,
Arturo

------------A------------B---------------C
1-----03/03/05---05/05/05----=IF($A1*$B1=0,"",OR(NETWORKDAYS($A1,$B1)))
= GIVES ANSWER - TRUE
-

guys and gals, little help..  I am working in a spreadsheet that has
22,000 records and I am trying to get a total for 3 different criteria.
So I am using the sumproduct  which looks like this:
=SUMPRODUCT(--(status="I"),--(grade=O5),--(SA=N6))

I have a very big spreadsheet.  When it goes over 1,000, not all records will
show in filter.  It will leave out the records at the bottom of the
spreadsheet.  I just went to an Excel class, and they said it's probably set
to 1,000, but autofilter could actually filter to 60,000 ...

I have an Excel worksheet in Internet Explorer and I want to print it in
"Landscape". How do I do this?? Do I have to adjust the registry settings? Or
can I program the XlViewer? Or make use of a template? What is the best and
most efficient way to do this?

I'm forget the password for unprotect the *.xls files

Dear Reader,
I'm trying to create a macro in Excel (for windows XP) which adds a certain
number of selected cells, for example 7 in a vertical direction, to a
selection of cells which are already highlighted before the button was