Hi, I am sure this will sound really simple, but my brain just isn't working.
I need a formula to find the differance between 2 cells. Any  help would be
much appreciated.
    A     B     C

If I want to type a letter in a cell, can I have that cell convert the letter
to a number ?example, type in A1 the letter A and have A1 return the number
8, or 8FF I am using Excel 2003

How can I format cells so that if I add say 10 degrees to a compass value of
355, Excel will return 005 rather than 345; in other words I want to work in
base 360.

does anyone know how to determine the name of the pivot table the user
has selected.
I have code I want to run against the selected pivot table however the
name of the pivot table is not constant nor is it always the first

When ever I open my excel file I get a error message when I press one of the
commandButtons.
Run Time Error'-2147352573 (80020003)':
Could not find the specified object.

Hello, All!
I have been  using Excel 2002, as the name implies, for quite a
long time but it still surprises me sometimes. Today, I
accidentally pressed CTRL-SHIFT-; and the time with hour and

I have a master worksheet with 7 columns of data.  In the second colum
of data, there will be five possible entries:1, 2, 3, OPS, HQ.  I
would like to pull all data associated with each possible entry to a
seperate to a page of its own. I am familiar with advanced filter so I

how do you hide formulas that you don't want people to know

How do I prevent Norton AntiVirus from scanning my spreadsheet every time I
open a spreadsheet I created ?

This formula works fine but it enters results before all data has been entered.
=INDEX(B10:B49,IF(COUNT(AP10:AP49)=COUNTIF(AP10:AP49,"<0"),MATCH(MAX(AP10:AP49),AP10:AP49,0),MATCH(MIN(IF(AP10:AP49>=0,AP10:AP49)),AP10:AP49,0)))
My question is can this be prevented until the all data ...

Can this be done?  I have a worksheet that I use to track scores on
the Army physical fitness test.  I use the sheet for unit level events
so there are soldiers from 5 different platoons.  I would like to pull
the data from this input sheet into a seperate sheet for each platoon

Trying to find closest match in column B for each unique entry in column A.
I have a list like this (very long):
ParentSKU  ManufacturerSKU
10028    A054150

I am trying to set up excel to predict what the value of an investment
would be. It would be an initial investment (say $5,000) with a 4.5%
interest yearly. I would also like to know how to factor in adding
money to the fund at the beginning of each month. I would like this

I have a pay sheet that has a cell that we use for leave can I use colors
i.e. red=sick leave blue=annual leave green=leave without pay and hve it
transfer that information to the appropriate column in another document in
excel?

I need to generate a set of random numbers. I know there is a way to do this;
I just do not know how to find it. Please help me