Is there a formula that will return the number of sheets in a workbook?
Thanks.

We have part numbers like this one "ACC0123". We are trying to seperate the
ACC and the 0123. However, when we do the text to column and fixed width, the
"0" gets dropped. Have changed the field to be text, general, number and
nothing seems to keep the "0".

Hello fom Steved
I have a worksheet named Bus Summary
In Col A I have City
In Col D I have 16-230

I am trying to create a list. When I click data on the menu bar there is no
list option to point to. I've gone to view on the menu bar, pointed to
toolbars and list is not there either. I am going to school online and one of
my lessons explains how to do this with those two ...

I think I need to use an "IF" function for the following but don't know how
to write if statements.  Can anybody help?
If Cell A is between 3,000 and 5,000 then multiply by 20%
Thanks!!

I need a macro to add a column its sum, right below the end of the column.
Column length (i.e. # of rows) is variable.
For instance, let's say data is in D1:D50,
I want the column total in cell D51.

I may be alone here, but I use filters on Excel sheets quite a lot, mainly
for the ease of sorting data without having to select the cells first.
Anyway, I find it quite annoying that everytime I want to sort my data in
ascending or descending order, I access the filter and then ...

For each month of the year, I have a budget column with sales and cost data
(e.g. in column B) and then next to that I have a column where the actual
data goes when the data is available.
                    Col B                 Col C               Col D            

I have to do conditonal formatting based on outline. Mena first layer will
have one format second different etc. Is there a way get out line in
functions? if you have other solution for this also most welcome.
Thanks

How do I used a big formula I created in Excel?

I maintain an Excel spreadsheet that contains inventory information suc
as Manufacturer, Model, Cost, Qty, Total Cost, Date Acquired.  The
column contains the dates in the mm/dd/yy format and the G colum
contains the quantity of each inventory item.

I have a customer who has a spreadsheet that has many columns. One of the
columns is filtered. The arrow about the column is blue and the other columns
have black arrows. Nothing happens when you click the blue arrow. You get no
options at all, nothing happens. It is the same way ...

Hi.  I have a possible array question, if in case an array is the most
appropriate.
I have a persons team selections that will proceed to second round in
sheet1( A1,B1,C1,D1).  If any of the persons team selection matches my

In my index/ match formula, what does the A3= reference.  My sheets are set
up this way:
Sheet 1
A            B                C        D        E          F

I have a range of dates for the month of June. A5:AD5.  I have
corresponding data below each date. A6:AD6.  I need to sum the data
values based on the date in a different cell.  For example, if the date
in A1=06/22/2006, then I need to sum the values in the Range A6:AD6 for