"Wednesday, May 30, 2007 2:07:30 PM"
Shows up as text in column B of my worksheet.  It is not defined as a
date and therefore sorts weird and cannot change format.  This is a
result of the data collection method I cannot change without tons of

I am looking for way to take data from worksheet 1 and link it to
worksheet 2.  However, I only want it to show the most current date.
This is what what worksheet 1 currently looks like:
    Company               Date    Amount

Just got a short question, I directly opened an Excel file from our
server, did the modification saved it(Overwrite the original copy.) Is
there any way to roll back or restore the original copy? Thanks a lot!
Sincerely,

I am using Microsoft office/excel 2007, vista2007. I just learned the excel
for 2002, I thought there would be a way for me to transfer these information
but I do not see how. How can I use the data on my excel to create mailing
labels?

Is there a way to link an external .exe file to a button on a
worksheet. I have a fortran program, which carries out a set of
analyses, that I would like to be able to call from a worksheet.
Many thanks

I am using a macro to direct the out print to two different printers and that
is ok,
But I am using a button in the sheet for it and when I am saving it as a
template and then are trying to use it I get the message cant find macro

well
i want to create a drop down list and some of my selections have a "symbol"
eg R
but when i go use the drop down all i get is R or U anything BUT the symbol

I'm trying to do some conditional formatting on a pivot table.
Category            2006          2007
aerials                 100           200
batteries              100          200

My EXCEL 2007 has switched to Numeric column notation and I can't switch find
how to switch it back to Alphameric.  As it sits, cell designations must be
written R1C1, R1C2 etc. rather than A1,B1 etc.  HELP.  I know this sounds
simple but EXCEL 2007 is substantially different ...

Is there any way to modify pivot table or pivot graph properdies from macro?
or from another page?
Let me explain the situation:
In both my pivot graph and pivot tables I show an item in the [Page Field]

I have created several excel workbooks which contain various macros
and vb code that requires worksheets and/or workbooks to be unlocked -
these all work ok - the problem is now i want to combine all the
different workbooks and therefore i need to change the some of the

the file name still the same but the contain is not the same. how to recover
the files

I was just working in MS Excel 2003. I opened the sheet to discuss over a
telephone call and made a number of alterations during the conversation.
When I went to save the sheet I was working on, a dialog box came up saying
that the sheet could not be saved due to a sharing ...

I have a macro (assigned to a button)  within my excel spreadsheet.  I want
to give this macro (and button) to several my colleagues for them to insert
into their spreadsheet.  What is the easiest way of doing this?
I right clicked on my button and selected Copy.  I then loaded up ...

I want to add two columns to a spreadsheet with the latitude and
longitude of the location, either in the format:
DEGREES MINUTES SECONDS or DEGREES MINUTES.DECIMINAL-MINUTES
How can I format the cells like this?