I need some help with two functions I know. If I need to
copy the same content in the above cell to the cell below
that I can use CTRL + D function. If I wish to copy the
content from the left cell to right cell I can use the

I am now working on a worksheet that require to write a
fomula to count the occurence of Column B item if the
Month of Column A is the same.
However the time format in Column is dd/mm/yy.

Hi I am using Microsoft Office 2000. I am an exel beginner and I though
this would be an easy function to create, but I have spent severa
hours trying to do this with no luck. I have an excel spreadsheet wher
I would like a formula that would do the following:

I set the UK date format fine, or appeared to.
Then, when I type in 250104 to bring about a date format of 25/01/04 but
after typing the date the cell reads 03/10/84.
I was always under the impression that if I typed in 250104 it would accept

I am writing a shift roster for 24 x 7 support. I do my
time calculations based on days of month. I achieve this
by filling up cells with all days of a month using formula
=IF(AC8="","",IF(MONTH(AC8+1)<>MONTH($B$4),"",AC8+1))

I want to set up worksheet to allow me to skip cells in
one keystroke:  For example, from A1 to F8 in one stroke.  
Can I do that?

For example, let say I want to count the content in
existed column and if strings length are more than 21
characters then i only leave down the 21 characters and
put the rest characters to a new column. The record maybe

In older versions of Excel, I can create a Grouped set of
columns or rows, password protect the sheet and am able to
expand (+) or collapse (-) the Groups.
In Excel 2002, once you protect a sheet, you can no longer

I've got a column that includes a code such as LMD and
either an E for employee or a F for family.  The LMD
would signify life, medical and dental.  I have looked
through the functions and can't find one to use with a

I wanted to highlight every other row automatically.  The
formula =ISEVEN(CELL("row",A2)) returns TRUE value when
pasted into cell A2, but it creates error message when
used in the Conditional Format dropdown box.  Is there

I am trying to figure out the keyboard shortcut for the
SUM function.

Fisrt, sorry for my poor English!!! :(
I have a problem with a function in a excel formula.
What i have is this:
I'm building a excel Sheet with my DIVX movies and DVD collection.

I am importing a text file that has a row of currency.  So
of the entries are negative, but are entered like 1.25-.
Excel seems to be recognizing this as a text file instead
of a negative number.  Is there a macro I can write or a

When I have a cell that has a lot of text in it, at a
certain point, the text just stops wrapping.  I'm not
sure if this is based on # of characters, words, or
carriage returns.  Has anyone else observed this

I've seen this done, but I can't find out ANYWHERE how to
do it. Each column header has a drop down menu listing
all the possible fills for those cells (for instance, if
you're working in a database of addresses, and you're