| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return cardinal number from ordinal number function - an example
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return cardinal number from ordinal number function - an example
What about 11, 12, or 13?
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return cardinal number from ordinal number function - an example
I should have added that I have formula and VBA examples to do
this properly on my site at http://www.cpearson.com/excel/ordinal.htm . -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... What about 11, 12, or 13? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a number instead of true/false with an if function? | New Users to Excel | |||
| Function that can return the row number | Excel Worksheet Functions | |||
| Function to return a month name from a number (1-12) that is not a | Excel Worksheet Functions | |||
| Is there a function that will return the page number? | Excel Worksheet Functions | |||
| function to return positive number or zero | Excel Programming | |||
Linear Mode
