I use Windows XP home edition and Microsoft Office 97.
Excel has suddenly started truncating the file name to the first letter of
the file name.
What do i need to do to correct the position?

How do a compute a simple percentage and how do i form a ratio. I am taking a
statistics class and this is the first time I have ever used excel and my
practice assignment says to compute the percentage of women and men enrolled
each year.

I need to make certain cells accept only "x" and nothing else. I have no
idea why this is becoming such a difficulty.
Also, I have data sets in there own colum. I need to mark an "x" under
yes, no, or not sure. However, if I move too fast, I might put an "x"

Can anyone tell me what the following message means and how to stop it please
'The extract range has a missing or illegal field name'
In simple language please - not even sure what extract range and field name
are.

Hi, I have a bunch of documents that are .csv in excel.  WHat I am doing is
opening each, deleteing a bunch of colums, autowidth and then saving the file
in another folder as an .xls file.  I have everything working but the
filename.  I cannot figure out how to do the following:

Preliminaries:
- I have Office 2003
- I have looked in the Help area and Archives
-If I knew how to better describe this I probably wouldn't be here...most of

Several of my toolbar buttons are associated with macros. Whenever I
update the toolbars I copy my .xlb file to the other 2 or 3 machines I
work on. However my Personal.xls file is not located in the same
folder on each machine. Consequently after copying the new .xlb file

Hey all
I have this line chart (with one series) and that I need to put upper
and lower control limits on.  How should I go about doing this?  Also,
is there a way to find the standard deviation without using the formula

Has anyone seen a good way to prevent the thousands of password removal
tools from working?
I would simply like the Excel protection to NOT be easily defeated by
the use of these tools.

I am using Excel 2000 (Version 9.06 SP3). The excel file is a utility which
helps collating data.
it keeps crashing and gives a kernel32.dll error
Content given below:

I have a column in a spreadsheet that I was given.  some of the values
read like this:
130539061305 or when not in the cell, like this: 1.30539E+11
I found this formula from someone who answered a post, and it works to

I have a macro in which I need to open a specific Excel file.
Unfortunately with the code below although I can open the file, whether
it is visible and can be accessed depends on how many other Excel files
are open.  How can I determine how many excel files are already open

Our work machines were replaced, but our profiles were migrated to the our
new machines.  This also included upgrading from Office 2K to Office 2K3.
On my previous machine, I must of had the following files (program.xls,
Post.xls, POSTExcel2k.xla).  Now I am getting the following ...

Hiii hope u are all ok. i have a problem about protect workbook.when i go to
tools menus and then point to Protection and click on the protect work book
to protect workbook can't be done as it should be.. probably i don't know the
proper way how to  protect a workbook........ plz ...

how can I sort column based on number of caracters in the cell.
Column is formated as text, values in cells are just numbers and
numbers and letters respectfully, number of caracters varies from 6 to
10, some of the cells in column have leading zeroes. I need to separate