software

How can i change text 2/27/2002 12:00AM (cell F2) into this date

Hello,

Anyone seen this before, and if so, is it a bug?

Hello

I have a spreadsheet, each cell has the name, address, etc.... all in each
cell. Not name in one cell, address in another, and so on. When i try to

=INDIRECT(A1amp;quot;!quot;amp;quot;B1quot;)--
Regards,

How can I get text to be shown in red if the value is less than 0.00?

I have a workbook in excel 2002 that has several worksheets within. There is
the first sheet into which all the data is imputed. each other sheet refers

If a word is found in a cell range in E2:AT2 I want the total sum found in
that column below the word, or alternatively, the total found in that column

I have an excel spreadsheet sent to me that contains blank rows. Is there a
way to get rid of the blank rows with a formula so I don't have to go through

I have over 1,000 records in an address data base. The street address field
contains both the house number and the street name. I need to place these in

I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range,

Is it possible to total the number of digits in a single cell? e.g. if a

Over a year ago a member of this forum directed me to a web sight with

How can I drag a formula without incrementing both of the cell values stated
in the formula?

when I am in excel worksheet and I right click delete - I can only delete
full column or full row. How can I get shift left and shift up option to

I have a spreadsheet in which I have an annual rate of interest (b5 which is
5%), number of years investment (b6 which is 3) and a future value in b7

VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

I am trying to find a function or any other means to add up a row of numbers. The example is:

In earlier versions of MS Office/Excel, I have easily extracted as .gif files
charts that I created in Excel worksheets. Either I've simply forgotten how