BIN2DEC conversion for large binary numbers19543 (12/15/2009 4:19:13 PM) Hello All,
I need your help, i want to convert large binary numbers using excel
but whenever i use the BIN2DEC function the result is negative which
is not correct.
Ex. BIN2DEC(1100110110) the result is... ahmedmidany
Goto Cell With Today's Or Other Date2330 (12/21/2009 10:02:01 PM) In a worksheet with a long list of dates (all in one column), how to go to
the cell containing a specific date?
a) today's date (using TODAY() reference?)
b) another, specified date
Changing my functions to use subtotals?6187 (12/21/2009 6:20:02 PM) I have 2 functions that are calculating my data correctly, except now I need
to consider the autofilter. I figure using subtotal is the way to go if I
want to disregard filtered out rows. Also, I plan on mo... Utf
MSN Stock Quotes not working0185 (12/22/2009 2:19:40 AM) Excel 2002 - Beginning today, the MSN Stock quote function returns VALUE!
and the toolbar icons are grayed out. Anyone know a workaround?
what does the "carat" character mean in Excel - answer8258 (11/30/2009 5:38:02 PM) Jackson -
I can't reply to your posting directly - I suspect the "^" character in your
posting subject may be the culprit.
To answer your question, the carat represents a 'to the power of' operation.
Finding second-to-last workday of month4313 (12/21/2009 9:07:01 PM) I am trying to find the second-to-last workday of every month for 2010.
So far, I have
but just returns the last workda... Utf
Countdiff with more criteria21163 (12/12/2009 12:53:22 PM) Hi All,
I would like to count a sort of diversity per person and per month.
Customer Engineer Date
A JP 01/11/2009
A Bill 01/11/2009
A Bill 01/11/2009
A J... JP
List of All Workbook's Worksheets4234 (12/17/2009 7:31:01 PM) I have a number of workbooks containing umpteen worksheets.
How do I enter, into an "index worksheet", say, a list of all current
worksheet tabs in that workbook, in the order in which they appear?
I'm us... Utf
extract last 2 characters from the right?81311 (12/21/2009 8:39:49 PM) Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?
in other words:
result would be: .1
Thanks in advance.