Hi all ,
In a cell which is B2 i have the following date 30-09-2005.Now how can
i assign a spinner to this date which is 38625 in order to increment 1
day at a time knowing that the spinner accepts maximum value as 30000

I have a macro that copies the last sheet to a new sheet at the end.  I
would like to note the date that is in A2 prior to the copy, and add
one month to it.
This result will then become the name of the new sheet in the form

I am calculating distances between 2 points.
Column A contains my 'X' location
Column B contains my 'Y' location
Column C contains the distance of the closest point:

I created a macro, and its saved in the personal list
I want to e-mail the macro to a co-worker -  how do I do this?
Thanks

example: =sum(a1-b1-c1) answer and formula in cell d1
if i delete the answer to this formula in cell d1 it also deletes
the formula.  i want the formula to stay in the cell d1
how can formula be locked or protected in cell d1 and still make

As a beginner, I find it difficult to know which lesson to choose from the
list ... I don't know what's basic and what is more advanced.  It would be
much more helpful if the basic lessons appeared first, followed by others in
order of difficulty, then finally special features.  

etc.) into excel.
If I click on a cell and click on "Format cells" and I click on numbe
and 2 decimal places. It does not work. The value keeps 6 decima

I apologize because I know that someone has probably asked this before
but I have tried Ecel help and have searched the forum to no avail.
I want to create a formula that will give me a specific answer base
upon the results of a calculation in another cell. For instance, an

I'd like to create a simple s/s to add deposits and deduct sums as a
checkbbok register and keep a running balance..say in differant columns.  
Help with that.
Thanks.

I've written two macros for a workbook and created a toolbar with two new
buttons - one for each macro.  Works fine.  When the cursor passes over a
button it shows "Custom Button 1" or "Custom Button 2".  I would like to
change the captions to something more meaningful.  Is this ...

Hello all..............first post from an extremely newbie Excel user.
My apologies if this particualr forum isnt the correct one for this
post, however here goes   :)
OK, I've attached scren print of an excel spreadsheet (small extract of

need help with formula.  i want the total number of cells that contain "yes"
from the following cells,G9,G10,G12,G13,G14,G18,G24 .. appreciate the help..

I have a series of numbers for example 1,2,33,23,80,73.
I want to know all the result these numbers add together.
is there a way?

I have calculated salary for one employee using =$A$2* 45 %. Now I want to
drag this for all employees, but Fill Handle does not work
Please help me

I have Excel 2002.  How do you export columns of data in a comma-delimited
text file?
Thanks