We have created a spreadsheet for a group of sales people. We have already
established the drop down boxes in numerous cells. What we want to have
happen is to make each drop down cell a "required cell" so that our
salespeople must choose an option in the cell each and every time ...

I need to add a different colour to the options in a drop down menu in excel,
I understand it is possible using the combobox, but cannot seem to do it!
any help greatly appreciated!

I would like to replace commas with a hyphen/dash.  For example cell
A1 contains "ABC,DEF,GHI", I would like to replace the "," with "-"
i.e. "ABC,DEF,GHI".
I attempted to use REPLACE(A1,FIND(CHAR(","),A1),1,",") but this only

I would like to replace commas with a hyphen/dash.  For example cell
A1 contains "ABC,DEF,GHI", I would like to replace the "," with "-"
i.e. "ABC,DEF,GHI".
I attempted to use REPLACE(A1,FIND(CHAR(","),A1),1,",") but this only

HI, NEED A LITTLE/MUCH HELP
Have excel sheet that I want to put data into, but true dialog boxes..
excample of data
A1                   B1                      C1               D1

I have some data in the following format:
Ref            Date
001           01/05/08
002a         10/05/08

Whenever i input house address eg 5/11 Smith St, the 5/11 changes to 5-June.  
How do I stop this and/or change the 5-June back to 5/11?

I need a simple macro that fill a cell of an excel sheet with some
data  that comes from the file name.
Example:
If the file name is 35.xls the cell(B,2) contains the text "35".

I have a set of 32 observations and I want to assign each value with its
corresponding decile. That means, at the end each observation will be
classified with values between 1 and 9. Does anybody knows how to handle that
in Excel? Thanks for your help.

please let me know how to create BCC option in the out look?

I am using Vista Home with office 2003 for past 1 year. Only Recently
whenever I try to save or close my excel file, it shown "Microsoft office
excel has stopped working". Can anyone help me? No problem with others office
program.

How do i copy the last cell containing a value from a column to another blank
cell. I have entered a sum formula into the first cell and copied it down the
column but will not always fill all the cells, in a cell at the bottom of the
cell i want to show the last balance.

I have a workbook full of data (Incident data reported to my helpdesk) that
is sorted into columns as follows:
Incident ID
Modified By

hi, i have a small problem..
in cell a1 and b1 i have some numbers, and i want in c1 to view the
diferences between a1 and b1 in percentage. but i want to have the percentage
to be negative or positive.

My company uses MS "companyweb" and I wonder if it's possible to publish a
Pivot-table on the web - that is, getting an interactive webpage?
(Alternative is to link to the original excel file, but I really dislike the
idea of opening different programs as the user clicks away)