Excel 2002 SP3
Win XP HE SP1
hi,
when i click on an xls file in windows explorer it opens the file in

Using Macro in excel for the first time and set up routine with an icon ..  
But only see a "Smilley Face" Icon for Macro and now have two macros with same Icon....
How do I add new Icon Image(s) to differentiate one Macro from the Other....
Lenny

Is thier a formula to use to change hous and minutes, just into minutes ex:
01:30 (1 hour and 30 minutes) into 90 minutes. And how do you format the
cells.
Thank you

I have an application used by both English and European clients.  This
is significant because often when European clients are entering Data
into the TextBoxes, they will accidentally enter it in the format that
they are used to:   1,000.00 in EU formatting = 1.000,00.   This of

I have a one-cell-named range called REQT and if there is a value
inserted, I want to go to a worksheet called RFP.  The variable
BeenThereAlready ensures this happens only once.  I made this one cell
a named range so that any modifications referring a specific cell would

Every time I put in #-## excel changes it to a date. Where do I turn this
feature off?

Table 1 (Purchases):
Column A has a list of part numbers.
Column B has a list of purchase dates.
Column C has a list of material costs unique to the part number and

Hi all, I am running into a problem. I am trying to sum values in a
table using arrays and I get the VALUE error.  My formula is something
like this.
{=SUM((A1:A10=A15)*(B1:B10=B15)*(C1:C10))}

I have a situation where I am creating a borrowing base for a company.  (I am
going to shorten numbers to make it easier.)  
There is a $300 loan.
Type A loan can borrow up to $300.

I have somehow lost my row and column #'s from my screen. How do I get them
back?

hai every body.
i m in a real bad fix.
i have a column containing names and other column containig their respective
datas. i made a function that when i will enter any name i will get the

I have an Excel sheet that I save as webpage and auto republish the
workbook every time it is saved.
The problem is that even when I change the location of "save as
webpage", it does'nt stop saving it as webpage at its previous

I can't remember or find how to turn off the formula bar in Excel 2003? Can
someone help please. This is the bar that displays cell contents up top.
Thanks!
--Randy Starkey

In case RD, Ken, or Barbara did not get my message, thanks for your help
with the last text function problem. Your examples and explanations were
very helpful!
Here's another problem. Here is a list of imported codes:

After selecting a range of cells to sum, when I select the AUTO SUM function
it returns "=SUM()" in the last cell selected.