Is there a setting somewhere to solve the following:
User wants to use auto fill to copy her formulas down a column.  When she
does this it is simply copying the answer from the previous cell.  Although
the formula is correct in the formula bar the result is not.

I have a text value separated by dashes like this: S057-T11S-R06E, that sits
in Col A.  I would like to MOVE the first 4 values (S057) to the end of the
string so that (S057) will sit AFTER (R06E).  I would like to new string to
sit in Col B.  How do I do that?

I have 2 Spreadsheets, one is a for monthly quotes and the other is for
monthly business obtained.
The quote sheet could have 100 entries but the business sheet would
only contain say 20 of those 100 entries.

is it possible to do that: change color of the all row when one of it
cell contains a negative amount ?
th
--

I had a 16 digit number in excel stored as text.  When I convert it to a
number the last digit becomes a zero.  Is there anyway that I can fix this?

Hoping someone out there will be able to help me with this...
I have a sheet of records, IP addresses and a count of how many time
each IP appear in the list, that looks something like:
Code

I'd appreciate your help with a formula. I'm trying to get the avarage
ages of all the people on a list that meet two different criteria. The
Ages are in column F and the criteria are in in columns A and B.
Could you please tell me what's wrong with my formula?  :confused: I'm

Can anyone help me to solve this problem. I have data in two columns and wish
to return a result depending on the contents of the two columns being true.
i.e. Column A contains 'Lab', 'Mats' or 'Stock' column B contains a
numerical value, what I wish to achieve is if A contains ...

Hi I need to do a function, I have the following columns and some sample data
Name         Week Number.        Estimated Hours
Yvonne        4                           2
Yvonne        4                           3

Hej,
how is it possible to look up a value in a dataset, when it's determined by
three differet "look up values"?

I want to make a cell in an excel spreadsheet have a blinking text effect as
I can do in Word - Is this possible

This is my first post so hello everyone and thankyou in advance for an
assistance you can provide.
The diffuclty I am having is as follows:
I have a spreadsheet with two times

Hej,
hvordan kan man slå op en verdi i en taball, når det er tre forskellige
betingelser som må være opfyldt?

I am using the VLOOKUP function and it is bringing in the result that
want - however, it is not bringing in the text color from th
originating cell. (The text it is finding on the first spreadsheet i
blue but when the function returns the answer onto the secon

I'm trying to subtract "30.06.05 00:00" from "31.07.05 23:59" and get
number of days and hours as result, but I cant seem to find the right
way to do this.
Im using Office XP (ie. Office 2002).