Hello, my english is bad, but i try...
whichever Mondays has in a certain month?
example: November 2006 = 4 Mondays
use Excel 2003

Can anyone help please?
I have a very long list of numbers each containing a forward slash i.e.
001/1, 002/3 etc
Does anyone know of a formula or macro to remove the slash?

I am using a VBA Code snippet which I am using to get around the conditional
format restriction.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer

I am having some trouble getting Excel 2003 sort to work correctly with
hyperlinks.  I entered a hundred rows of data, where one of the columns
contains hyperlinks to files on my computer.  When I try to sort my
data by the first column, the text of the hyperlinks changes as it

I always see excel sheets with nice names on top of the columns but I can't
find out how to do it.  I always seem to have narrow columns with longer
names that look goofy when do them now. For instance one column would be
Black or Color, so every column below that would only need ...

I want to export an excel spreadsheet to an HTML file, but I want
friends that do not use windows )they use linux) to use it , as well as
people who not have MS Office 2003 web components to be able to view
it.

How can I find gaps in a column of serial numbers, gaps can be of one number
or more, gaps can appear several time in the same line. Example:
10010
10011

Hi. Using Excel (office) 97 and Win-ME and Pentium 4 with 256 megs ram.
Trying to sort a spreadsheet. I have sorted THIS spreadsheet numerous
times. Now, when I select a grid of all the cells with data in them, as
I have done before, I'm getting a message that reads:

Hi, I asked a similar question and got a great answer, but now I have a more
detailed question...This is what I want to do I just don't know how to write
the formula... in a worksheet titled DAILY cell N9 to do the following: If
worksheet titled HARDLINES' cell C11 has a time ...

I have a range of data from A2:A140  in one excel file and an other
file which basically is like a template.
The data from the cells A2:A140 ( one at a time) should write into Cell
C4 of the template file and then save the file as  (DATA.A2) PFSR

Excel 2002 SP3
Win XP HE SP1
hi,
altho i have done this countless times in the past, i can't get my

is it possible to format a cell conditionally in such a way, that the
content appears in a certain format if the cell contains a value or text and
in another format if the cell contains the address of another cell?
Thank you very much in advance,

Excel 2002 SP3
Win XP HE SP1
how do i use a range name that is defined in 1 excel file with a formula
i am writing in another excel file?

I'm trying to record a macro, in which I need one of the cells to do a
vLookup in the sheet to the right of the active sheet, but I don't know how
to make it insert the name of the sheet to the right.
Here's what I have right now:

I need to count the number of cells in a range whose leftmost character
is an S, or an L.
I attempted to use the formula to count the cells starting with "S":
{=SUMPRODUCT(LEFT(H7:H134,1)="S")}