Hello, I would like to add the file extension .jpg to the end of the contents
of every cell in column A.
Right now I have cells with contents like
2004-11-034

Does anyone know how to remove negative signs from formula results? This is
more than just a formatting thing as the figures need to remain positive when
a vlookup draws the data to another sheet and then when the data is imported
into another program.

When I copy data in one sheet to another sheet , the data is automatically
changed.  The cells being transferred where all data that has been entered
with no cell functions being used.  For example, I have dates in the format
month/day/year that show different dates when copied ...

I am trying to average & obtain Sd based on last 10 results entered into
Sheet. the sheet is constantly being added to.
Some cells contain Blanks, which are distorting my results
Any suggestions

I'm using an array formula to give a count of rows from a big data table.  I
want a count of all records which are in a certain month, and in a certain
region.
In the Data sheet Col A contains the month and Col C is the region.  In

I am having a little trouble with this formula and was hoping for some help.
=IF(A1="X","Complete",IF(A1="",IF(OR(N1="Bond",N1="Other"),"Yes",IF(AND(N1="Government",OR(V1>7,W1>1)),"Yes","???"))))
If N1 equals "government" AND (V1 is >7 and less than 100) OR (W1 is >0 and
less than ...

What do I need to do if I want to leave the cell blank if non of the criteria
met?
I've tried this nested IF function in cell A3:
If(AND(A1="YES",A2"OK"),True_Action, Else

I have a number of worksheets that I use on an annual basis, updated monthly.
It is best if I keep each worksheet and save it indefinitely because it is
finacnce related. Since I have to recreate every year it would be fastest if
I could use the completed one and update the tab ...

How to write the criteria in the formula as NOT EQUAL TO?
For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

I have a worksheet with a hyperlink to a program outside Excel. This is
working fine at this point with one exception. Every time you click on
the link Excel puts up a message box stating the following:
“Some files can contain viruses or otherwise be harmful to your

I am trying to pull information from one work sheet to another.
on one work sheet  in colomn A there are several names and in column B there
are several numbers.
       A                         B

I have a field that has four sets of information that I need separated.  
example:
PE PS C5 270
GR HJ L6 876

I recently asked for help looking up values in one column by the year in
another column on different worksheets, and was very kindly given the
following solution:
=SUMPRODUCT(--(YEAR(INDIRECT("'"&A3&"'!H8:H1000"))=2008),INDIRECT("'"&A3&"'!I8:I1000"))

I am using the offset function, in the following formula:
=OFFSET($B$7,,COUNTA(Dates))
I want to use the Named Range, "Dates" I to establish the reference
cell "$B$7" rather than actuality entering the reference cell, which

I have a MS Access DB that export an excel sheet and in one of the
columns it has a formula stored as string with the little " ' " in
front of the " = " sign.
To convert it manually I select the range and run the text to columns.