Ok,
 I'm pretty sure this feature existed (as I recalled using it in Excel
several versions ago). Now that I need to work with lots of data in
different worksheets in a workbook, I find myself severely wanting this

I have a column that contains dates in a format like this...
     25-Mar-05
How would I write a Macro that would take this data and convert it to a
format like this...?

I was sent an Excel worksheet, and told there is a way to open this file
without having Excel installed on my machine.  This worksheet contains
calculation formulas, so I'm wondering if a) I can get the file open somehow
without buying Excel and b) if there is a way to open the ...

I've created two macron that executes calculations on a certain row.
Can I copy these macros so that they can execute the same calculations
but on a another row i.e. only on one row at the time leaving the
others unaffected.  

I want Excel to only count cells with < 3 value.  Here is what I used, but
this is wrong.  Can anyone tell me what I am doing wrong?
=COUNTIF(('Monitor Tool'!N11:N26,'Monitor Tool'!N20:26)"<" &Data!C1)
Renee

I am a relative beginner when it comes to Excel; is there a glossary of any
kind that breaks down the specific components of formulas so I can gain a
better understanding of how to construct them?
Thanks very much!

I have to sort 12 columns of numeric data in descending order on a
excel worksheet. I currently sort 3 at a time and then move forward.
For example, I have sales data for months Jan to Dec. I want each of
these columns to show zeros at the bottom when the macro is run. The

I am currently paying my employees on a percentage basis.  However, my new
payroll company is requesting that I turn in hours for employees.  Because
my staff is paid on a percentage basis they can work as much or a little as
they wish.

Is there an objet variable that would tell me the current running
macro/module?
Thank's ahead.

I have a problem with a macro which I have recorded in Excel. The macro
comes with an error in running the recorded script. This error is:
Run-time error '1004': Application-defined of object-defined error.
This is the VBA-coding which has the problem:

I am trying to create a function that will automatically allocate
conference attendees to a meeting group, based on their preferences. I
have a spreadsheet with the following info:
Attendee                Group1          Group2          Group3

I have a spreadsheet with 31,000 rows, column A has a number that is
duplicated numerous times.  There are 7500 different numbers in the
column, I want to know how many times each number appears.  Is this
possible?

I've looked back on several thousand messages or so and haven't seen
this so here goes. I need to be able to set the numerical format of a
cell based upon the contents of another cell. In other words if C1 is
equal to x than the numerical format of C2 would be "00000" and if C1

I am trying to create a party list such as a wedding list.  Then I want to
use that list to 1) print mailing labels  2)  send a list of the people for
the calligrapher to type the envelopes.

I need help; I am a new user to excel.  I have to create a spreadsheet that
estimates the most fuel effecient vehicle based on criteria that I have
already provided.