We are running Excel 2000 (part of office 2000) on a windows 2000 terminal
server. When the user was running excel they used to be able to minimise a
worksheet (not excel) down, the worksheet title bar would be placed at the
bottom of the excel window and the worksheet name would be ...

If I calculate:
Speed: 90km/h
Distance: 1240 km
1240/90=13,77777

I can't find how to do this...
I am working in worksheet Sheet2 and have inserted this formula in cell C3
=IF(B3=7,Sheet1!B49*Sheet1!B61,IF(B3=6,Sheet1!B48*Sheet1!B61,IF(B3<6,Sheet1!B47*Sheet1!B61,0)))
the formula works OK.

I would like to set up a button in a spreadsheet that adds 2 years to the
value of of the currently selected cell containing a date. the forumla would
look something like this: =DATE(YEAR(A1)+2,MONTH(A2),DAY(A3)) but is there a
way I can have this formula applied to a cell when I ...

I'm importing some data from access. In my table, I can have duplicate
data, for example:
accounting_code  profit_center     period          value
10                            3                 0701            100

 I know this is probably an easy fix, but I'm at a loss as to how to do it.
I've copied the two Macro's in question at the bottom of this email.
I have a number of (Source) spreadsheets/workbooks and they all have a tab
called "today".

When I graph items against date, the time scale is not even.  For example,
if I have the following dates 2000, 2005, 2006, 2007, there will be the same
amount of space between 2000 - 2005 as between 2005-2006.  Is there a way to
make the time scale correct?

Somtimes with my formula's I have #N/A.
But when you print or show the file to someone, it doesn't look very nice
like that.
Can I put some extra formula in it of with conditional format?

Hi Friends,
I am in requirement of a formula for extracting only last seven (or
less) numerical digits from a reference.
Ex -

How do I encrypt a column (numbers) in Excel 2007?

I am trying to create a little macro that will create a Page Header,
containing "page n of n".
I have used "record a macro" to create the macro.
But, when I run the resulting macro, it gives an error "unable to set the

I have a spreadsheet where the user inputs two or three abbreviated
letters such as, wb,sa,crc, etc.
Is there a way to make the letters they input into the cell turn into
all caps?

I want to average the amount of time someone spends on a specific date
with customers.  I have it average the person by user for the entire
time (1 week), but I want to average it per day. I am looking to
create a formula that looks at 2 columns (Column D has dates, Column I

I am desperately in need of help:
I have a workbook with missing dates and would like excel to insert
any missing dates and add 0's into that missing dates if there is no
data..

i have the following formula
=IF(MONTH($B:$B)=MONTH(J1),+SUMIF($H:$H,"auto",$F:$F)+SUMIF($H:
$H,"auto",$E:$E))
problem is i am getting results (sum) of all of column F and E