I would like to format numbers so that they appear as ordinals
ex
1     1st
2     2nd

Trevor Shuttleworth kindly wrote this formula for me:
A1=300
A2=g
300    This weight 300 is in g

My discovery on DATEDIF ("yd") and leap year
A1:A4
     2/1/2007
     3/1/2008

I am attempting to cut and paste an entire row from a change action
from one worksheet to one named "Closed" with the current script:
Public Sub Worksheet_Change(ByVal Target As Excel.Range)
   If Target.Value = "Complete" Then

I have got this code from another thread in my search for a solution to
a cell firing a macro.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myCell As Range

(Note:  I also posted this on Excel / General questions.  I hope I'm not
violating a rule by double-posting.)
I've got a table A2:Z100, with X's in some of the cells.  A row may have one
or multiple Xs.  I'm trying to find the number of rows which are "pureplays",

i have data in sheet one in one column and say many intermidiate rows
i want to copy that on a new sheet and then sort that
can anyone tell me how to do the linking using VBA
thanks in advance

I create a new spreadsheet every week that tracks employee tips.  Each
employee has their own sheet in the workbook, and each week has its own
workbook.  The employee sheets have their hours worked each day of the week,
their tips calcualted for the day, and their tip total for ...

I have a cell that has a mixture of text and numbers. The text comes
through fine, but the numbers only come through as numbers whole ie 300
not 300.00. EG:
="This weight "&A1&" is in "&A2

I have an annual report that includes a workbook of 16 pages that I want to
duplex.  When I go to print using the duplex feature it still prints single
pages.

I need a fucntion that can lookup a value and pull out corresponding
information (that resides in multiple cells for that value) and paste that
information into one cell seperated by commas. Is there a functionthat
accomplish this?

I know this should be easy but I'm having a difficult time making this
formula. I need a formula that would do the example listed below:
For example, if B2 was a number between 1-100, it would return a "1" in B3,
and

In relation to my previous post titled: "Matrix multiplication using
sumproduct"
I also need to calculate the determinant of a matrix.
Is there any add-in or easy way to perform it in Excel?

In some engineering calculations, we have multiplication of matrices or
matrices and vectors.
It is defined as follows by an example:
[A]= 2  3  5 (an array of  3 rows and 3 columns)

I'd like to combine a sumif and vlookup function. Basically I want to lookup
a "Name" in a table and sum up the corresponding grades (multiple cells) in
another table. Can anyone help. Thanks