I am having a problem converting dates stored as text to dates.  I keyed in
=DATEVALUE(,A131,). However it keeps giving me an error message.  Please help!
Thank You,
Carter

I am trying to use the sumproduct equation and I am get a VALUE
response.
I am trying to sum up information that is presented in columns F
through W, with each column represent a certain weekday.  I then have

Even though I have resized the cells and wrapped text, the total contents of
cells with a lot of data in them are not visible in the worksheet. The full
cell contents are only visible in the formula bar.

.

In rows 1 through 10, I want my column width to be "20"
In rows 11 through 20, I want my column width to be "4"
How do I do this ?
Thanks

I have a spreadsheet with four columns A to D, where C is the result of a
value that is a division of the value in B by the monthly Rate of Exchange.
We defined the value in C as having two decimals. The value in D is the
addition of A, B and C. When we add up the values in D ...

Im trying to group numbers together and was told to use Vlookup- but dont
know how??

Sytem details - Office 2003 - Windows XP - Bloomberg Installed adn running

I'm trying to select a range of dates in an expense report. Colomn A has
dates from Jan 1 through Dec 31 2005. Colomn B lists a store name and colomn
C and D have other data.
I can filter any kind of numbers or text, but can't find a way to do the

I need a one simlpe function to return true if all the pairs are entered
correctly in both Column A and B and false if ANY of the pairs misses an
entry in either Column A or B. To illustrate:
(True)  

A simple function question.
What is a function that returns Truse if all the selected cells are
validated as True by ISNUMBER function and False if any of them is False?
Something like {=ISNUMBER(A1:A10)}???

how do i calculate age in term of years, months, days

I need a clever Trevor to help me crack the following regular expression
find-replace issue (I think...):
I have the following 3 columns in an excel sheet.
Using the 1st row as an example, Column 1 reads

I am trying to run an IF statement but not sure if it is appropriate because
it is involves text. What I have so far is along the lines of
=IF(A1:A10=Sheet2!B2,Run Numeric Statement,0).
What I am trying through the function to achieve is this:

I wish to write inside the margins in Excel.  How?