I have street addresses in 1 column - I want to seperate into 2 columns the
first being the number and the second being the street name.  I'm using the
function MID but I have to keep changing when amount of numbers difer.  Must
be a better way.

Excel provides functions to calculate a variety of numbers for mortgages
(when they have a monthly compounding interest rate) but I cannot find
functions to generate those numbers when the quoted annual rate is compounded
on a semi annual basis.

In a spreadsheet, we want one field in a row to turn grey if a date is
entered into another field along that column, otherwise it retains the colour
it started with.
Any ideas?

How can I prevent 3 tabs of a 6 tab workbook from being printed automatically
if someone clicks on print workbook - they are refernece tabs only which
shoudl never be printed.
Thanks

I have many cells in which the special order price of an item needs to be
manually entered.  I would like to conditional format the "cost" if the cost
= $0 and there is a qty greater than 0.
w10=0 and p10>0 turn yellow

Does anybody know how to perform a Lagrange interpolation given a set of
known y's and x's?

Is there a short cut key that will allow me to alternate between worksheets
within the same spreadsheet?  Thanks!

We have a spreadsheet containing closing dates. We'd like the closing date
field on a row to turn red once the closing date has passed (i.e. today is
later than the closing date).
BUT we'd like that field to revert to its original colour pattern once a

I would like to add page numbers (page of page) to a specific cell, NOT the
header or footer.  Is this possible and if so how.  (Excel 2003)

Is it possible to have a formula to feed down automaticly, as I don't know
how many entry's there will be, and having mutible formulas on every line,
I'm looking for a way that I can put a formula in and when the data is
entered into the first column , the formuia will move to ...

I cannot find the right function to solve for the number of years it takes
for money to double given interest as a variable.  It's a simple calculation,
but there does not seem to be a function for it.  Input terms:
Amount of money

I have just read a brilliant post on using a sumbold formula however I was
wondering if there was a way to do a formula to add all the values that
aren't in bold as well?
Thanks in advance!

I have a template that I'm trying to develop for daily use in my
office. The template is a tool to help my supervisors check the work
for the next day. I work for a service organization that covers a 3
state area.....I have routers that plan the day for the techs but I

How do I concatenate two cells - one with a start date and the other with an
end date without Excel changing it to date values?
i.e I want to end up with 01/01/2006 - 31/12/2006 not 38718-39082

I need to add "8" to the total amount in a cell automatically on the 1st of
every month. I understand I can use the OnTime function for this if excel is
running at the time that I set. If Excel is not running at that time, can I
set it up to enter that digit the first time I open ...