...been reading some posts regarding the cell's capability for text
length and there is definitely a problem...
While the help states that 1024 of the 32K characters will be
displayed in the cell vs the formula bar, using the len function, i

I have been working on an issue for a while with excel, both 2003 and
2007, where excel is taking a very long time to open when I double
click on a file. If I open excel and then open the file it is
instantaneous. If I open the same file by double clicking on it in

I have a spreadsheet which lists a date and time as 1/02/2007 8:31:36
AM. I would like to be able to add the day of the week for the date in
column A. It would be preferred to have the day appear directly in the
column but would be acceptable to add a column for it.

When you click on any cell and click to format it, tabs do not display
properly.

I have for the most part converted to Excel but have a simple macro that on
the surface cannot be converted.
The Lotus macro used a database, template and list of branch names. The
macro itself started with the name of the first branch, copied it to the

I have a huge database of game items from an online game spread across
several sheets, and I'm trying to finda match.  The problem is that my
search string is  often a substring of the main alpha field in the
excel database.

Re: Excel 97 file [from Office 97 Pro Suite] which I created and have been
using for years.  
Suddenly it will not open and gives the message "Microsoft
Excel has encountered a problem...".  This is a tax file with data from 3

Howdy all,
My question is this for those who know Excel very well.  I would like to
know if it possible to stop a person inserting or deleting rows or columns on
a spreadsheet just like the protection but not using the protection as data

Using XP, Office 2003
Without using a template, is it possible to, every time, open a new workbook
with say filename and date in the footer?
If not, will this be possible in Vista/Office2007?

I have three dependent lists.  The lists are working just fine.
List 1      List 2         List 3
If, after selecting an item in each list, you go back and change and item,
the dependent lists do not update.  Also, if you delete a selected item, the

I am having a hard time figuring out how to do the following.  I want to
create a spreadsheet that calculates a trailing stop for a stock.  The
premise is that I want to sell the security if the price drops by a certain
user entered percentage.  I have the excel add-in "Stock ...

System: Excel 2000 on win98
I've been searching the NGs and googling for Excel 2000 templates.
The only ones I've found are for 2003 and above.
Specifically, I'm looking for one that might be used (or converted)

Anyone familiar with the Lotus @INDEX function and the Excel equivelant, if
any? For those that may not be familiar, its in effect a combination of
vertical and horizontal lookups in one formula.

here is my problem.
I type 9.1 -> I get september 1 (In my country decimal is ",", but lots of
files comes with ".")
Thats nothing, it is easy to correct, but I'am using copy/paste from lots of

Hi,
I've created a pivot table. It looks like this:
Item1   Sum of Total         9
           Count of Names   2