I have a problem in Excel 2003, the result I get when I enter the =Month
function with a date from September (9) gives me a January result.
No idea why it's donig it.  

I have an inherited spreadsheet that is password protected. I enter the
password then another dialog box pops up saying that this file is
"reserved". I enter the password again and the file opens. How do I get rid
of the "reserved" box?

I am a student I Niagera college and am working with excel, I have a n
ifstatmet that is giving the correct answer but its not solving the anser.
The statment :    =IF(G9>B3,+"sum(G9*C3)",+"sum(G9*1)")
The Answer  sum(G9*C3)

Hello all.  I need some help and hope someone out there can assist me.
I have a spreadsheet with 100 or so lines with serveral columns goin
across.  I want to insert a blank line in between each line tha
contains data.  Is this possible?

I have a chart (clustered columns) based on a pivot table.
Sales are grouped by years & quarters.
The quarters are shown in chronological sequence on the X-axis.
But I want the X-axis shows Q1 from Y1, Q1 from Y2, Q1 from Y3, - Q2 from

I am printing with gridlines, but some of my cells are blocked wit
yellow, and the gridlines do not appear throghout those cells, onl
solid yellow.  Any solution for this?  I'm using Microsoft Excel 2000
--

I'm working on MS Excel.  I am trying to find the source code for
something that will allow me to do the following novel procedure with a
pull-down menu and a text box:  There is a pull-down menu, and another
text box right besides the pull-down menu.  The pull-down menu has the

I'm just getting into this VBA lark with Excel and have come across a
problem! :confused:
I'm used to creating macros by pressing the little record button
selecting the rows and editing them as usual. I then press play and it

Hi group,
How can I see negative hours on Excel?
I´ve subtracted 12:00 from 9:00 and the result should be -3:00, and Excel
shows #####. How can I solve that?

Hi: Would any one have a xl template for making lease purchase decisions?

*Multi selection within an array, ending with sum*: what combination o
functions do I need to use to select a subset within an array and the
select within this subset a new selection which I can then sum a colum
within this last subset.

Is it possible to set conditional formating in all cells which starts with
"Tot.", as in "Tot. Product 1", "Tot. Product 2". I only find number
statements in the Conditional formating dialoge and not "If cell begins
with....."

A few days ago, I did receive very good help from Max and Dave to
achieve the following formula,
=IF(B5="Synth",INDEX(AUTOS!$K$10:$K$500,MATCH(1,(Autos!$F$10:$F$500='ID'!D5)*(Autos!$G$10:$G$400='ID'!$R$2)*(AUTOS!$I$10:$I$400="C"),0))-INDEX(AUTOS!$K$10:$K$500,MATCH(1,(AUTOS!$F$10 ...

I have two columns of information 'Customer' and 'busy hour' I have over 200
entries for each column and want to put the information into a chart, can
this be done?
Thank you in advance

I have a tricky excel macro opportunity.....
My sheet(s) consist of sales data for a number of companies, populating
columns A through to O.
Column A lists company names.