I have a spreadsheet with what excel refers to as a negative date, example:
20030112. What I want to do is format the date as 2003/01/12 or 01/12/2003,
but I can't find anything that works. I've used the format date function, the
DATEVALUE function; formatted the date as text, ...

I have a pivot table with two row fields. Excel does a nice job of formatting
the table automatically, but it includes a total line when the first field
changes value. I don't want this subtotal line. Is there any way to get rid of
it?

Hello.  I am wondering if someone can help to pull the price (3rd column) on
worksheet B into worksheet A, based on the priceclass.  I know that on the
worksheets below, the price classes do not match, but in the full list that I
have,

I need a worksheet function that will tell me the most frequent occurrence
of a single character string in a range of cells, the second most, and the
third most.
Example

Can I use a wildcard character in an "IF" statement?  For example, if any of
the data in a column contains "1B*", I want to return a certain answer.  I
tried typing it in that way, and it was rejected.  Couldn't find the answer
in Excel help.  

I need some assistance in doing a SUM function.  The cells I am trying to SUM
may have an #VALUE error in them.  How do I get the SUM to not include those
cells?
Thanks.

I have been trying to print off the sheet that I am using to check the
formulas myself. I know there is a way to do this but can't seem to remember
how.
Thanks

i am using excel 2003 and am trying to use the SUMIF statement with the below
calculation:
=SUMIF('U:\Operations Reports\[Open Orders
020607.xls]Sheet1'!$B:$B,"Entered",'U:\Operations Reports\[Open Orders

Have a spreadsheet containing vendor names in column A, and the column
headings of C,D,E,F and G contain criteria names for evaluating them
in a number of ways.
All data then entered in these columns C,D, E, F, or G contain either

I have a combo box that contains a drop down box of over 11,000 part numbers;
I would like to be able to input my part number without going through the
whole list on the drop down.  Is this possible?
Excel 2003

Hello from Steved
The below formula works perfectly except if no data it leaves a small square
box which siguests to me it is a character, please how do I modify the
formula below so that this only leaves a clear cell if no data.

I have a calander that was made and one cell has two dates in it.  How can I
put a line between the two numbers and color one half of the cell.  I know
it can be done because it is on on of our calanders.  I am attaching a file
with what I want.  In the attach. I would like to ...

I've used SUMIF for simple calculations such as:
SUMIF($F$32:$F$39,"Contracted",$H$32:$H$39)
on a single sheet.
How would I work that using INDIRECT to perform that same function for

Say I have this
    1     2
A   f1    f2
B   ?      ?

why do the numbers 1 thru 9 convert to text in word and excel