just i need to convert time format from one zone to another zone
E.g : EST into IST format.

I have 1000+ records over 4 years & want to count how many for each month &
year ie May 2005. Records have specific days 4 May 2005
I can use :
=SUMPRODUCT(--(YEAR(c2:c1000)=2005),--(MONTH(c2:c1000)=4)) to pick up

What would be the most efficient way of returning the value of the first
NON-ZERO value in a column.
THANK YOU

I have a spreadsheet with values formatted in one column in red and some in
black.
What function or formula can I use to count only the numbers in red?
many thanks

A colleague of mine has an Excel spreadsheet (a fairly large one...but it
appears it should be well withing the capacity of the program) which has many
columns containing formula
He is convinced Excel is hanging because it has all these calculations to

There is a line on my header in 2007 excel that I don't want. It is like a
bottom border. How do I get rid of it. I can't find any place to format the
header so it is not there.

Is there a way to make it so every number entered in a worksheet is
automatically rounded up?  My work wants the numbers rounded up (12.01
rounded up to 13.00), however they want the actually amount to be typed in
for possible future audits.  

this is what one line looks like, for example:
Boom     5       bling      4      ding     3
i want to apply a cell format that would make the cells look like this:
"('Boom',     '5',       'bling',       '4',      'ding',     '3')"

In prior Excel programs you could display the current contents of a cell in a
message type bar.  How can this be turned on in 2007 if it is available.  
Help has been less than helpful in this matter.

I have this small and quick question but I don't know how to do it without
knowing anything about Excel Functions. Any help would be really appreciated!

In an area, say from column A to Z, Row 2 to 20, some of the cells have a

I am to begin calculating rep commissions in the coming months based
on a "tiered" or "step" method.  The rep commissions will be based on
YTD sales and their commissions % will increase as they surpasse four
different "steps"--0%-100%, 100.01-125%, 125.01-150% &  >150% of YTD

This problem has bugged me for a long time. Please help!
I have column A with 2, 4, 6, 8, ....100, which represents the time line in
days. Column B with 0, 0, 1, 0, 3, 2, ...5, 3... which represents a certain
event that happend in that day. Let's say totally the event happened ...

I use keyboard shortcuts all the time. When I go to copy a cell with
control-C in Office 2003, the Edit menu pops up next to the cell. Then I have
to select Copy. This defeats the purpose of using a keyboard shortcut. What
gives?

I typed a bunch of words in a cell.  The cell is formated to wrap text and as
text.  All I get are ###################.  If I click in it it converts to
what I typed.  I click out and ##############.  I have resized the cell to
fit the words (oversized it).  It is only doing this ...

Trying to use the INDIRECT function to allow me to use a drop list, and
based on my choice, I bring the data from a similarly name worksheet.  This
data resides in the same place on all worksheets.  In the formula below, I
have the worksheet name and the column and row.  You can ...