Where cells M12 and M15 contain the number 39315 and 39317, respectively.  
The formula yields no results when M12 and M15 are in the formula.  However,
when I substitute the actual number in the formula, the proper result is
produced.

I've seen some users with different colored excel workbooks. One person in
another office has a  black backround with white fonts. How do I  customize
how excel looks on my computer? ~Thanks

In column C I have the date, in column D I have the time, and in column E I
have a measurement taken at that date/time period.  There’s 25,000+ rows of
this data, so doing what I need wouldn’t be something easily done manually.
Based on the date and time, I would like to find the ...

I have the macro below that will show the counter on the printed sheet but I
need the number to change with each print from the right header text. I was
lucky to get the code below and information from Gord Dibben and Gary''s
Student. I would really appreciate any help I can get. ...

Is there a quick way to populate a range of number from one cell, e.g.,
230-235 in cell A1 to their individual cell:
230 (in A1)   231 (in B1)   232 (in C1)   233 (in D1)   234 (in E1)   235
(in F1)?

Please show me how to go from:
234-238 (in one cell) to: 234   235   236   237   238 (each in individual
cell).
My worksheet has so many of these numbers and can't use "FILL".

Is there a formula that you can total all of the + or - in one cell?  For
example if the cell shows =+5-3-8+9 what is the formula that would add the +
totals and would equal 14?

i am looking for some amendment to a SUMIF or SUMPRODUCT.
i have a table of that shows data in columns going down in rows in the order
of a product hierarchy, like this;
        A                 B

I've recently begun working with the sheet protection feature of Excel and am
naturally confused by it Unside-down logic...  In trying to figure out my
problem it seems that I need a way to quick view on screen either the locked
cells or the unlocked cells --- the Special.. key ...

I have a fairly wide cell but the text is short.  I wish to underline the
TEXT ONLY but not the entire cell.  Can that be achieved?

Dear Sir,
My PC at the workplace is running on Window 2000 Professional OS.
I have Excel and PDF files saved under my personal and shared drive.
May I know is there a way to protect certain files from being deleted from

Dear Sir,
I  know how to protect a worksheet (page) at a time by going to Tool >
Protection > Protect Sheet > Enter Passwords Twice.
If I have a file with 20 worksheets, may I know what is the shortest way to

I am trying to create a time sheet for our staff to use bi-weekly (1st thru
15th and then another sheet for 16th through last day of month).
If our people enter at 8.00 and leave for lunch at 1.00 (pm), can anyone
tell me how to enter a formul which will give me the 5 hours that ...

HOw to change max in a cell automatically
A1=some value   that I will change all the time.
B1=  another value
I want to Change B1 to A1 if A1 >B1 otherwise B1 keep to its value.

I have a spreadsheet called Book1 with 2000 lines.  
Where there is a dup in rate , name and month I want to remove the dup  
lines from the spreadsheet.  Keeping just one line.
If the price is diff but same month, name and rate i want to keep in the