Hi, I was wondering if somebody could help me.
I have a list of data I have imported, it is 7 numbers across and
continues down a long way.
I am trying to use the COUNTIF function but I'm not sure if this is

I have Excel 2002 SP3 and when I format cells to use numbers all numbers
show up with a decimal and then are rounded up. For example. I want to put
inventory numbers in column A such as number 394. The result is that the
number shows up in the formula bar as three POINT nine four ...

What is the best way to set up an address book/phone book for home use?  I
also want to use this same book to print out label for Christmas cards.  What
is the best way to do all of this?

I seem to remember that there is a way of specifying a set of rows and
columns that get printed out at the top and left of each sheet when printing
a worksheet that gets split into multiple sheets.
                                           Don J

I have read several posts regarding nesting, but I haven't quite found
what has perplexed me for the last couple of hours.
I'm using a set of IF functions to check 12 different cells to see if
they match a particular cell. If it does, it returns a value of a

I'm downloading names in a .cvs file, and many don't have the first letter
capitalized, or the whole name is capitalized. This file then gets imported
into an autoresponder and shoots out emails, but the names go out as
downloaded. How can I get them properly capitalized before ...

I've set up a work evaluation workbook with multiple worksheets.  For
explanation sake I'll stick with my first worksheet titled "Jan". I
have set it up where I have a name column, month column, shift column
an various other columns for evaluatin purposes.  below the names and

I have created a user form VBA.  When I open the VBA Project window I have:
VBAProject (file name)
 + Microsoft Excel Objects
      Sheet 1

I would like the value of the cells in column A to be equal to the value
of the previous nonblank value in column A +1.
For example:
    A

I just installed Office 2003 and I want to change the color of the icon that

I have a list of names in a column that contains  Mr. or Mrs.  First Name
and Last name.  What I want to do is to have a seperate column for Mr. or
Mrs., a seperated column for the First Name and a seperate column for the
Last Name.  Is there a formula in Excel to do this?  Any ...

I want to keep a running balance in a budget , month on month and I
understand that its not best to use an accumalator.  I was advised to have
twelve separate tabs which is fine and I have copied the sheet to the next
tab but I don't know how to link cells from one sheet to ...

I use the formula: =SUM(IF((Feeder!$E$9:$E$2008=$A11),IF((Feeder!$E
$9:$E$2008=1),1,0)))
When I use the same formula to another columns and changes the $E into
$N it doesn't work.

I would like execute a file dqy in vba excel please do you have the command
for to do it
thank you

Does anyone know how to make a hidden sheet invisible?
Thanks,
llee2