i'm using Excel 2003 on Windows xp srvc pk 2
When I try to join "concatenate" a number and a text cell, both formatted as
"general" or 'text" I get an error value unless I use an ampersand.
i.e. =A2,C2   returns error value

I have a form with a few different cells that users enter numbers and other
info.  Right after they enter these numbers this info should automatically be
entered into the next page (same sheet) into other cells with same label
info.  How can you automatically update other cells ...

Excel 2000
How do I write a SUMIF function, such that the matching text criterion
matches the first five characters of the string in the cells of the
range to be evaluated for a match?  Something like the following:

I got a problem with Hyperlink function, and see if anyone knows how to fix
it:
My spreadsheet has 2 columns:
- Column A (from A2..A10 is the Parameter)

I have a series of 900 ten digit numbers.  All of the numbers start with the
same 3 digits and I need to omit those (leaving just the last 7 digits).  Can
this be done without have to manually delete the 1st 3 digits on each?  
I appreciate you taking the time to read this and ...

I need a formuls that will take all of the Characters after a colon in
a cell.
I Have:
B3 =  LastName : Jones

I'm not even sure if VLOOKUP is what I should use...
The spreadsheet I am working with has multiple columns containing accounts
payable information: invoice numbers, costs, invoice dates, and a code for
the buyer that purchased the items on the invoice.

Hi, I wonder if anybody can help
In cell A1 there are multiple options eg London, Birmingham, Manchester, I
twould like a data validation list to appear in cell B! based on the value in
cell B1 so if it is London I have a drop down list of Waterloo, Victoria,

Ok.. I've spent the last 2 hours reading this area trying to find a close
enough match to what I am looking for. I know this will be simple.. but I've
ended up having to post.. I'm sorry :(.
This is what I have..

When I use the following formula:
=HLOOKUP(A11,INDIRECT("'"&$A11&"'!D2:H104"),3,FALSE)
with a lease number 003403 - everything is fine and the correct data is
returned.

Hello I have a data sheet that looks likes this:
Reading Date         Site 1      Site 2     Site 3    Site 4   .....
Jun 1,2007             XP          XP          D          XP
Jun 2, 2007            XP          D            D          P

88922 divide it into 7271.00 by 100%

HELP! I need to average a colum of numbers omiting zero values, I found the
formula in the help menu and copied it using my cell ranges when I try to
enter formula it returns an error message with the false value highlighted
this is my formula:

First I want to thank Gord Dibben for the correct answer to my last question
and forcing me to accept that I need an eye exam I couldn't tell the
difference between asterisks and quote symbols on screen. I need to find the
Min value in a column of numbers but I need the formula ...

I have a value in A9 that i want to look up in range B2:B6 and return an X if
it is there and blank if it is not. How?