How can i change text 2/27/2002 12:00AM (cell F2) into this dat
27/02/2002 ? (cellF3). Also 11/27/2002 12:00AM into 27/11/2002
Thank
--

I have a column of numbers and want to color highlight the lowest number in
the column.  However, I only want to color highlight if there is a clear
"winner".  Ties should not activate the color.  There is a posted article on
the MS site (article 909845) using an IF statment but ...

Working with a large spreadsheet.  I will engage Autofilter and want to add a
section at the bottom for subtotals pertaining to the filtered data shown.  
What formula(s) would I use for that since it would change for each filter
selection?

I would like to use a formula like COUNTIF or SUMPRODUCT to test two ranges.  
I want the formula to return the value of the number of cells that meet the
two conditions.  Both columns contain TEXT, not numbers.
Like this:

I'm trying to create a weekly timesheet in which I enter the time each day an
employee begins, and the time he quits, then total the hours worked that
shift.  Some employees work from the afternoon of one day till the morning of
the next day.  I can't seem to figure out how to ...

How can I select only cells that are colored in yellow in Excel?

I am using Excel 2000 and need to count the incidents of a defined value in a
column unless another defined value occurs in a different column in the same
row. For example, count the value "FAM" in column $A2:$A100 unless the value
"Cancelled" appears in the same row in column ...

I am working on 2006 pricing for our home improvement company. One of
our suppliers said they are raising their prices by a certain
percentage. I created a simple formula to get this years pricing.
=C4*6%+C4  I was wondering if there was a way to make that cell become

as above

I have a simple 2 column list that shows Title Insurance Rates.  Left column
gives a 2 number price range.  Right column provides the Title Insurance
amount for that home value.
Column 1

I don't think there are any problems in this "if" statement, but it's not
returning any values; it just shows the entire formula in the cell.
=IF(E18<0,"=sum(c24-e17)-c17","=sum(c24-c17)")
When I test the statements separately, they come back with a value just

I need to make a chart or graph showing costs from several diffrent tabs on
one spreadsheet. Can I do that?

I am trying to come up with a formula to compare 2 dates and highlight the
cell if a certain result is reached.  Here is the logic:
IF RC[-2]-RC[-8]=3
    IF RC[-8]<>Thursday

I'm running into a brain buster for my simple mind.  
I want to be able to put an number into a cell, but have a word sho
instead.  Is this possible?  For example:  in Cell A1, I will typ
"000053", but would like "Frontier" to show.  Any help will be greatl