I have a calcualtion that adds up all klms driven up to 500 klms, then
multiplies this number by 35 Kenya Shillngs to give the total amount
that can be claimed. Absolute beginners stuff.
However I am having problems with the calculation if the total klms

Dear Excel gurus,
1) I have been trying to rank customers by amount of sales. Each
customer belongs to a region and its rank is relative to its peers from
the same region, not the whole list of clients. While this problem is

i recently export some data to excel, which give me the date format as text,
example:
20060515
how can i convert it to dd/mm/yy format in excel?

I have a Sheet1 where Column E has numeriv values. I would like to match
these values with a list in Sheet 2 where Column A contains the numeric list
and Column B contains corresponding values. I want to then return the
corresponding value in Sheet 1 Column G. I would like to then ...

How I do this....
+-------------------------------------------------------------------+

I know this is probably a simple thing, but how do I lock or protect
cells which I do not want the user to modify?  For example, if I allow
the user to enter data into cells A and B but C uses a function to
calculate the result of A and B, I want to lock the result cell so they

When i enter a fraction as 10/5 it automatically calculates it to 2. Is there
a way to automatically calculate something like 2.89/5 and have it calculate
it as .578? Any help is greatly appreciated.

one excel workbook has a very long loading time.
How can I see, what excel does?
The workbook is several excel-versions old.
Maybe that is causing the long loading times.

I have purchased a program in excel and I am getting the followin
message when I use the macro:-
Runtime Error ‘1004’ unable to set the printquality property of th
pagesetup class

What I am trying to do is to create some form of notification when
certain date is reached.
For Example:
There will be a date in Cell C4 and some information in Cell C3.

Is there a quick way to actually grab cells C33 and F4 on each of the
worksheets and place them on a fresh worksheet in three columns (third
one would be the date from A3 & A9 ) Do I have to get into some form of
VBA to do this? Date form would be '3-May-2006 to 9-May-2006'

I want to add the total hours worked in excel that I book for the month for
example:
A                 B                 C
Start Time    End Time      Total

is there a way in excel to get the linear regression function to
specify a function based on a set intercept (say =1), instead of a set
intercept.
I believe this ability should have been included in excel from day 1.

Here's my situation, I work at a hotel in the security dept. everyday we
receive lost and found items. we keep these items for 30 days, if not
claimed they go to the employee who found it. We use excel to make out
a list of the employees that are about to receive there lost and ...

I wrote a Macro that inserts content of a given file
How can I check VB (Macro in Excel) if a file exist in
What is wrong wih this script? It does not like the set fso... line ("Object
Required")