I have about 50 worksheets in a workbook and would like to change the date
format in all. Is there a way to change all at once or must it be done
worksheet by worksheet?

I know Excell 2000 is fairly powerful, so I think it should be able to
do this, only... I can't seem to find the right helpfile for it.

What I want to do is. Take List of Data in column 1, Have Excel compare

All of a sudden, I am unable to open Excel files from Windows Explorer.  I
have to open Excel and then open files from within Excel.  Any ideas as to
why this might happen?
Thanks.

I've got a 'quotation system' and i need to work out a way, so when
press i button (I've got the button) it recognises the last entry pu
in 'Customer Details'.
I just need some idea of the marco or whatever i will have to use.

class problem; sensitivity reports used by prof show headings final value,
reduced cost objective constraint, allowable increase,allowable decrease
(etc); mine only shows final value and Reduced gradient; how do I make
sensitivity report show up with the other headings; text book ...

Within a cell I'm attempting to create a number of bullets e.g.
1) get tickets, 2) get money, 3) take out dog
Visually can I create a list which would look like:
1) get tickets,

I don't know if that would work or not. I've never used a VLOOKUP code
I'll have to see if I can learn how to do that
--
Phunnybon

I need to move a list of address from Word to Excel so I can import the Excel
data file into a shared Outlook address book.   I can simply Copy & Paste,
but how can I set up the Excel worksheet so that it will import  correctly
into Outlook?  TIA

Barbara,
That is exactly what I am after. I have downloaded the file but I can'
seem to locate the additional maintenance tab on the toolbar fo
amending it!

In the Tools menu\Options box or window,
If I try to make any changes or even choose a different tab along the top, I
get an error message saying- Can not access directory "F:\All Files:"  Which
is the partition the files are stored on but they are few folders below

Forgive me if I have posted in the wrong section but it is my first
post.
I am looking to use a spreadsheet to contain a league table and fixture
list for a church league which has ten teams playing each other twice in

Everyday several factory worker produce mattress in my factory. I scan the
production ticket and enter the qty produced by SKU nos on different
worksheets. Every worker has different worksheet. All the worksheet are then
summed up to give the total qty produced.

I have a new problem with Excel, which appeared suddenly.
I can launch Excel from the Start menu, and open any .xls workbook.
But I cannot simply double-click a .xls file from Explore, as it
launches Excel ok, but fails to open the file, and just hangs there

DEAR EXCELMAN,
I want multiple and sum below array,for example:
A         B          
1         10      

I?d like to retrieve data from a table in sheet 1 into financia
statements in sheet 2, sheet 3, sheet 4 and sheet 5.  
Within data source sheet 1:
Column A has various cities ? New York, LA, Boston etc