/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

1 vote155 views1 answer
Perform http request in vb.net
VBA
1 vote132 views1 answer
Excel vba unload userform
VBA
0 vote135 views1 answer
Vba word open document read only
VBA
4 votes134 views2 answers
Excel vba last column with data
VBA
-1 vote127 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote151 views1 answer
Excel vba move down to next visible cell
VBA
2 votes86 views2 answers
Vba exit loop
VBA
0 vote137 views1 answer
Convert number to minutes in vba
VBA
0 vote146 views1 answer
Excel web scraping
VBA
15 votes253 views2 answers
Xl vba dynamic string array
VBA