I am using a data validation that covers 26 rows of a list.  When you click
the cell with the drop down, only 8 items of the 26 show.  You have to use
the scroll bar on the right side of the drop down to see the remaining items.
Is there a way to set the DV/drop down to show all ...

I am trying to write a program to collect scores of basketbal games. Here is
what I have. Column A is the team and where they played (varies). Column B is
the score. I would like to look-up the team (ignoring where they played) and
add all the score together. In The Below example ...

I know its possible to have a symbol/text repeat before or after text in a
field.
Using, for example, *- custom number format.
Is it possible to have a repeating character before and after text?  

I'm trying to use auto fill for a column of dates.  But when I use the fill
series command (with day selected as date unit and step value 1) it changes
the year instead of the day.

I have expenses listed in a spreadsheet and I want to separate the data into
departments in order to give a monthly expense status report to each
department head?

I changed a .txt file to be saved with a .xls extension.  If I try
opening the file in Excel, I get an error saying "the file has a
different extension than specified by the file extension....verify if
the file is not corrupted...do you want to open file?"  Then, if I

I need to edit a loan amortization schedule to calculate payments using a 360
day basis instead of the standard 365.  How can I edit a current template to
use 360 instead of 365 days in a year?

Is there a way to move data from Excel to a tab-delimited text file and have
Excel throw the tabs in?
As an example I currently have 4 columns (one row) of data:
   Cell A1:  ABCDEF

Been asked by a colleague if there's a function that is in essence a search
function that returns true or false. I'm sure there is one but for the life
of me I can't think what it is!!
Basically what they're trying to do is have 6 columns of copious amounts of

I have a very elaborate spreadsheet that is used by most of the people in my
office.  I have three columns that contain formulas that calculate 30, 60 &
120 days from the date keyed into a specific column (ie: =bk2+30).  Before a
date is entered into [bk2] the date that is ...

I have a protect macro that runs whenever the workbook is opened and this
works well whenever a user attempts to overwrite a locked cell.  However, if
the user just selects a locked cell then hits the delete key the cell is
deleted!

I am trying to write a program to collect scores of basketbal games. Here is
what I have. Column A is the team and where they played (varies). Column B is
the score. I would like to look-up the team (ignoring where they played) and
add all the scores together. In The Below ...

In excel as I type in 1 to a cell, it turns into Jan immediatley.
I tried Format > Number, it didn't work.
Please help,
Cheers

Suppose I have text in cell A3 such as "2+1/4". I want Excel 2003 to evaluate
that as a formula and put the resulting value - namely 2.25 - in another
cell. Can it do this?
I have a vague memory, perhaps of another spread sheet, that one could

I am having a problem with an excel model that I created.  It has to be
circular by nature, so I have turned calculations off and have to F9 whenever
I want the model's formulas updated.  
The problem that I'm having is that I have pages that sum up values from