Hi , i was wondering , is it possible to generate a number sequence , for
example i have 100 items , i need to have them numbered as focus-00001
through to focus-00100 , is there a command in excel that would allow this ,
also when i add to the list , i would like to be able to ...

I have a column in a Sheet (A10:A24) which has integer numbers (from 1 to
80). I would like to apply in the bottom cell A25 the condition: If all
numbers in column A10:A24 are different each other return “OK” else return
“R”.

Excel 2002 SP3
Win XP HE
Hi,
I know how to hide multiple worksheets at once, but cannot seem to find

I'm trying to count the number of columns that contain values where one row
is greater than the other.  For instance,
Data1    5    8    9    3
Data2    16    81    49    1

I created a drop down list using the data, validation menu. It works well.
However, I only have two items in the list and I am wondering if there is a
better way to alternate between them. With the drop down list it takes a
couple of clicks. First you select the cell, then you ...

When I type in the 16 digits, Excel changes the last digit to 0 so I don't
have a correct number listed.
How can I get it to accept all 16 digits correctly?
Thanks

Is there an easy way of changing the order of the three conditional
formats for a cell, or do I just have to re-type them all?
Thanks - Dave.

I have VBA code for inserting a picture as a header with the following code:
       With ActiveSheet.PageSetup
       .CenterHeader = "&G"
       .CenterHeaderPicture.Filename =

Tab one is 2006, tab two is 2007..  Tab 3 is difference.
Tab 1 (2006) will have text then $$ in  columns  C to O (12 columns and
total ), Tab 2 will have text then $$ in columns C to O ( 12 columns and
total).

Is there a way to protect and unprotect *multiple* sheets at once. All the
sheets have the same password (say 1234).

How can type 0700hrs in a cell ? it always reverts to 700hrs.
Is there any way that fill series does not work? for eg I have typed 1 and 2
in column when I click and drag to fill series it only fills as 1 not the
sequence 3, 4 ...

I have install office 2003
I used to access data from a foxpro programm in excel 2000 ealier, but since
I have install ms office 2003, excel databases shwoing only  debase file ,
excel file MS Acess database.

I trying to figure out how to SUMIF only if the data in a cell is not shaded
gray.
On my spreadsheet, once an item in a column is shaded gray, it is complete.
If it is shaded any other color it is an accounts receivable. So I'm trying

I am able to use conditional formatting with "value equal to"
=TODAY(), on a cell that is formatted as d (date)
But I failed to do use the same conditional formatting for a cell with
format "mmmm" (example: June).

Can someone assist. I'm fiddling around with some basic VBS programming.
When I want to select multiple rows (i.e 3-9)  from an sheet I can use
Rows(" 3 , 9 ").select
However what should I do when one of those argument is a variable.