First of all please apologize for my poor english...Im more comfy in
french.
My question is this:
I create a function that use only one argument :

First of all, I wanted to say 'Thank You' to everyone who post replies on
this site.  I cannot speak for everyone, but I always appreciate when someone
take the time and effort to reply.  Thank You!
Now my question.  I work in Human Resources and I need to run reports on an

I have somehow messed up my tel numbers.. idiot!
Previously 011 740 1342, 082 443 0707 and 09 64 456 8799 in different cells.
Now 117401342, 824430707 and 9644568799. Cells are formatted as "numbers, 0
decimals"

I need to add worksheets all the time to a file we use. When I add the
worksheet I want it to automatically take the value of the previous worksheet
and add it to a cell on the new worksheet.
For example:

On sheet 1 Ihave a list of numbers in column c.  
On sheet 2 in column a will be numbers that correspond to sheet 1 column c.  
Then sheet 2 column D will have a number hard keyed.
I need a formula on sheet 1 column I that finds the corresponding number on

I got this question at work - just wondering if anyone can help me out - i
know the logic, just not the code :(
Im guessing i need to find the cell the mouse is in before i click my
button, then set a variable to this, which will replce the reference to cell

I have a data cell that lists the sum of times, but it displays in a format
with colons in it.  I want to convert that data to a SINGLE NUMBER.  For
example, I would like to convert 170:41:19 to 614479 (the number of seconds
in 170 hours, 41 minutes and 19 seconds).  I have more ...

is there a maximum # of embedded IF statements allowed in excel 2002? if so,
how can i sort a list of numeric values into groups?
i have a column of numbers that i want to seperate into groups. i.e.:
1-50=group1, 51-150=group2, 151-300=group3,...1000-1300=group14, >1300=group15

We have a table/spreadsheet that has various weight categories set up in
columns and various mile categories set up in rows, where the intercept of
the two is the rate per pound we charge for delivery.  We are attempting to
set up a formula that based on the weight it will find ...

Is it possible to import a Union Query from Access into Excel, via
MSQuery?
I keep getting a bogus error that there is no data being returned, when
it works fine in Access.

I am working on a customers excel file.
Currently, when I copy a cell, it gets selected. When I click on any other
cell to
paste, the selected cell loses it's selection, and I cannot Paste.

Excel 2003 v.11
=HLOOKUP(W2,WholeYear,13) = #VALUE!
Where WholeYear is a named range Jan:Dec!$L$2:$AP$17, that spans 12
worksheets.  The first row in the range (Row 2) contains the 365 days of the

I have a "fairly" complex spreadsheet with about 10 worksheets, each with
about 700 rows of info.  On two of them, I have created my own user defined
function for some complex calculations to simply the forumula.
The problem is that it is not calculating. I do have calculation set ...

I am trying to keep trackof credit card numbers, i put in a custom formating
that looks like this: ####-####-####-#### so i can just type the numbers in
without having to type '-'.
The only problem is that is always turns the last number into a '0' zero.

Is there a quick and easy way to do add up the number of times a text string
is entered in a column?
For example:
Column A: