How can I extract/copy the time from 1 column to another and successfully
apply a time format of 00:00 to the new column/data?
I imported tab delimited data which contains 2 columns with time values.
The first time column successfully receives the time format 00:00 (I do this

Hi every body
I'm a new member to this forum.
I've a prbleb.  In Excel 2002, if I type a value 1 in any of the cell,
the cell displays 0.0001 and for 2 it'll display 0.0002 and if I type

Someone put a password on an excel document that i need to use.  Neither the
teacher, nor myself know who did it or what the password is.  how can i
change/get rid of the password protection.

I have a large block of columns which I had to delimit, then change the info
inside, and now I have to put that information back into the original single
column it came from.
How can I do this?

Been using Excel for years but haven't asked this question until now...
Could have saved myself a few days likely!
Anyway, say I type BACON in a cell and press enter or tab - the focus moves
to the cell below. If I arrow back up to the cell that has BACON in it, how

Thanks for your reply.
I have never worked with Macros.
I did go to the site sugested and downloaded 1st file under filter
named "filtersAdvFilterRepFiltered.xls"

How do you effectively hide a worksheet when you are distributing an Excel
workbook for someone to review or make additions to.  You can use the
Format - Sheet - Hide command to hide a sheet and with Workbook protections
turned on the sheet can not be unhidden.  However, if the ...

I need to build a spreadsheet which when a person selects a particular
option on one column than options dependant on that selection are given in
the next.
So for example if car colour blue us selected in column A, then black,

corpse_make_list={{[magic_ring];1;1;12.0603};{[stem];1;1;3.9799}}
This is the data in the cell, for a game. The last two numbers 12.0603 and
3.9799 are what I need to change, they vary throughout the column.
Is there a way i can make a formula for this to change each end number by ...

CAN U RECORD A MACRO ASSIGN TO A BUTTON AND CUT AND PASTE IT TO A DIFFERANT ROW
IE:  THE MACRO IS ASSIGNED TO A BUTTON NEXT TO A4
THE MACRO COPYS A1 TO A2
I WANT TO COPY THIS MACRO TO A BUTTON NEXT TO B4 AND THE MACRO WILL COPY B1

Sorry, but I am a noob with an urgent question
Lets say I have a list of 10 dates in a column
How do I show the earliest date in the 11th row?
How do I do it across 2 rows of data?

Not sure if this exactly the right subforum, but here goes:
I'm going to be manipulating fairly large (though maybe not to some
spreadsheets (well, after they're imported from either TXT or CS
files) - some will need quite a bit of work while others will need onl

I have a list of employees that I want to track uniform issue.  I woul
like to take each row and make a sheet for it, but I don't want to d
it one by one, by hand.  Is there some short cut to make a sheet fo
each row?  Thanks for your help,

The spreadsheet is not protected
--
jcm122
-----------------------------------------------------------------------

what are reason why i can't save a workbook in excel97/2000(e.g.
OQAWW26.xls), error message received: Document Not Saved.
any workaround to fix this problem; is there any fixes available in
Microsoft.