I want to be able to change decimal answers in excel to the power of, e.g.:
0.006 to 6 x10-3

I am trying to write an argument that states if aq3=bi3 and f3=bm3. if
true return a 1 if false return a 0. Everytime i try to write it i get
an error, cell aq3 has a formula in it but i dont think it would cause
this problem.

To open workbook to same worksheet I using macro
Private Sub Workbook_Open()
    Sheets (“trips”).Select
End Sub

Referring to the post in General Question
I get a list of numbers as show below
58,58,58,39,39,52,37,43,55,58,55,52.
I would like to the largest one, which is 58, and the second largest one,

I am making a form and some of the border lines do not show up.  When I click
on the format it shows the lines are there, but they are not on the for or
the print preview.  I printed the form and some of the lines are not there.

Would you please help me create a formual that will return one of five values?
If B11 is  less than 1000, enter 0 in D11
If B11 is more than 1000 and less than 2000, enter 1 in D11
If B11 is more than 2000 and less than 3000 enter 2 in D11

Here is my question.  If I have one workbook that contains 20 sheets and
that each sheet contains info on each of the 20 different people what I want
to be able to do is send out this one workbook to the 20 different people
but for each person I want them to enter there own password ...

I would like to be able to sum numbers from a portion of a text string if the
number meets a condition. The cells of data are in a row. The data looks like
the following:
1x1.5

What formula would I use for the following:
B3 contains the following formula:
=(A2-e4)/18
I wish B3 to be to be displayed as a whole number rounded down.

Say I have sheet 1 that has
  Rt#   O   D
  ----------------
    A    B    C

I've a button on an excel file and clicking on it will copy sheets
from another excel file. The sheets are copied but what happens is
that in the copied sheets, in the formulas, it copies the file name
from where the sheets are copied. Is there any way where I can just

I have a column of dates (I4:I30) with a column next to it for data that has
a new number in it weekly (J4:J30) for 26 weeks that is deducted from a
constant. I then have the result in J2. I can manually change the formula in
J2 weekly to have that weeks current result, but want ...

I have a workbook with macros. Now I want a toolbar that appears only when I
open that specific workbook and disappears when I close the workbook. I can
not make this work as I want so if someone can help me, I´d be very happy. I
am running Excel 2003.

Can I extend the total length of a loan in the amortization past the 30 years
maximum?  If so, how?  I need to calculate a loan for 34 years.

Workbook containing two sheets
Sheet1 = trips
Some cells in ColumnB is blank (0)
       ColumnA            ColumnB