sometimes I'm comfortable with the previous notation for
region(eg.A1:B3) instead of [#this row],[column name].
how to change the way of notation?
thanks.

I am trying to change the background colour of a cell based on another
cells value.
For instance,
Column E allows numbers 1,2,3,4,5 or 6

how to handle string as a number
equivalent to Integer.parseInt or Float.parseFloat as in Java.
Thanks.

I have a correct formula, but instead of getting the result displayed, I get
the formula.

conditional formatting is so confusing.
especially "using formula".
in the box for "format when the next formula is true"
what format can be?

Not able to get an answer to this in General Questions Forum - so trying here:
Is it possible to have Excel automatically extend the width of a column as
text is entered.  That is, instead of the text spilling over into the
adjoining cell, the column automatically increases in ...

I have numbers in a colum from L5-L12, which range from 44 to 26. I'd
like a function that will fill in the corresponding ranking in the M
column next to it.
Since 44 is the largest number, I'd like it to put "1" in the M cell

I have data in row with certain cells blank and certain cells have 0
value. I want to transpose row into column but only want non-blank and
non zero cells. Like if data is:
1 blank 2 0 3

I'm a newbie and was wondering can anyone help with my query.
I am trying to find out how to print a spreadsheet with just the data that
is contained in certain cell address's.
Where a cell address is not populated I want the whole row to not appear in

-Someone asked me to setup a spreadsheet like this
cell b2 is entered as a date
cell c2 is entered as a number
cell d2 is a calculated date =b2+c2

I want to use a time value presented in hours and minutes as a number that
can be used to multiply to get a value.  ie. so many hours and minutes
equals a number and using that number times a dollars per hour number to get
a gross.

I have set up a little spreadsheet using "start time" and "end time".  The
resulting difference is expressed in hours and minutes.  I would like to use
this figure to calculate pay.  It is not doing that because of the
formating.  Is there a way?

I need to create a formula that will count everything in a column except for
4 items (Medicare, Medicaid, Self Pay and blanks).  I use =COUNTIF to get
seperate totals on all those but the blanks, ie.
=COUNTIF(Sheet1!B2:B400,"MEDICARE") etc.  But now I need to count ALL the

I'm currently using MS Excel (2002) to keep track of inventory and sales in
a VERY small home-based business.  Would it be possible to set up something
in Excel so that when I entered a sale on one worksheet it would
automatically be subtracted from inventory and, if so, where ...

When I type, for example, "4-44" (without the quotation marks) into a cell,
Excel automatically transforms the data into a date ("Apr-44").
How do I stop this?
Thanks!