return cardinal number from ordinal number function - an example

A

aztecbrainsurgeon

No question here, just a custom function for the archive


Return an ordinal number (e.g., 1st, 2nd, 3rd) from a cardinal number
(e.g., 1, 2, 3, etc).


Function OrdinalNumberReturn(TargetCell As String) As String
'return ordinal number (e.g. 1st,2nd,3rd) from a cardinal number
'(e.g.,1,2,3,etc).

If TargetCell = "" Then
OrdinalNumberReturn = ""
Else

Select Case Right(TargetCell, 1)

Case 1
OrdinalNumberReturn = TargetCell & "st"
Case 2
OrdinalNumberReturn = TargetCell & "nd"
Case 3
OrdinalNumberReturn = TargetCell & "rd"
Case Else
OrdinalNumberReturn = TargetCell & "th"
End Select
End If
End Function


search criteria
return ordinal number from a cardinal number
convert to ordinal number ordinal conversion
get the ordinal number evaluate for ordinal number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A #NAME? problem with a transferred function 11
proximity position test for character(s) function - an example 0
Copy partial cell character format(s) from one cell to another - an example 0
Conversion from Number to Word!! Aki 1
how do I format numbers to ordinal i.e. 1st, 2nd etc 9
Optional argument as Variant not acting like number 4
Join two tables 0
Regex Pattern 11

Top