I would like to know if there is a way that I can stop Excel from simplifying
fractions.  For example...
I'd like the fraction to remain 5/15.  Excel simplifies this to 1/3.  
Thank you for any help.

I have a several _array_ formulas (written by someone else) that are breaking
up a long text string into smaller parts (without splitting a word in half).
I'm trying to usnerstand what the function is actually doing.
The first function (which pulls out the first 40 characters ...

I have created a pivot table that lists account numbers, names, and the type
of service.  I would like the account number and name to repeat for each
service type within that account (right now it is only showing the one time).
The reason being is that I need to filter on the ...

Excel 2002.  I created a custom number format to eliminate the leading zero.
Example: from 0.210 to .210 if there is a better way to do this please advise.
I then need to use the value from that cell in a concatenation formula.
Example: =CONCATENATE("3A",B18,"     ","Control ...

I need to return the position of a cell in a list. For example, I have
the list:
A
B

Returning Descending Values
I currently use the following to find the max number is a column:
=MAX($P$4:$P$65536).  If I wanted to find the second highest, then the third
highest, etc.. how would this be written?

I have a detailed calculation in Excel and wish to run that calculation
for a range of input values. I can use the Tools, Scenarios but this
requires that I manually enter each of the input values. I am looking
for a way to get the input values from a list of values in Excel.

I have two columns where values are entered, I want to prevent entry in
say B5 if a value is entered in A5 and so on down the columns.
Any help appreciated.

I am using the following formula in a worksheet, it works perfectly, however,
it is so long that it hides the first 8 or 9 lines of my spreadsheet when I
click on the cell containing it.  Is there a shorter way to do the same thing?
=INDEX('[Weekly Sales by Department

I have a list of values down a column, e.g.
a
a
a

I download a query that has a column of dates displayed without the
seperators (20040830). When I try to convert these cells to reflect a date,
nothing changes. No matter what I tell the format to llok like, it remains as
20040830. I can only change this to 2004/08/30 or ...

I have been using the function
=IF(COUNTIF(H:H,"Rory")>0,I21,"")
It will return the value of cell of I21 if the name "Rory" is in column
H. I need to know if I can so that instead of returning I21, it can

I work in an office where we share an excel spreadsheet.  Comments are made
on different projects we are working on.  I need a formula to show when a
comment cell has been updated.  Basically it timestamps when a change has
been made to an adjacent cell.

I thought there was a way to rename the A B C columns on the top of an excel
worksheet.  Does anyone know how to do this?  I would really appreciate it.
Thanks
Treasuris

What I want is if the radio button (named "VolorInvol") is selected, it
performs the formula in the cell, if the radio button is not marked I want
the cell to be blank.  Here's my code but it doesn't work, what am I doing
wrong?