/VBA/Excel vba get ordinal number from cardinal number

Excel vba get ordinal number from cardinal number

Function Ordinal(n)
  Ordinal = n & Evaluate("IF(OR(--RIGHT(" & n & ",2)={11,12,13}),""th"",IFERROR(CHOOSE(RIGHT(" & n & "),""st"",""nd"",""rd""),""th""))")
End Function

Source: stackoverflow.com

Similar codes

0 vote230 views1 answer
Vb test if reference is null
VBA
0 vote216 views1 answer
Vba leading zeros in string
VBA
0 vote214 views1 answer
Vbnet add new ecel sheet
VBA
0 vote240 views1 answer
Vba string
VBA
27 votes495 views2 answers
Vba check if file exists
VBA
0 vote237 views1 answer
Vbnet line chart showing extra space
VBA
0 vote231 views1 answer
Xlbycolumns is not declared
VBA
1 vote229 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
1 vote227 views1 answer
Excel date to unix timestamp
VBA
0 vote256 views1 answer
Excel vba urlmon
VBA