/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 vote222 views1 answer
Average vba
VBA
5 votes253 views1 answer
Vba low word from Long Integer
VBA
0 vote214 views1 answer
Vbscript abs
VBA
4 votes258 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote232 views1 answer
Vba sheet hide unhide
VBA
0 vote311 views1 answer
Vba line feed
VBA
0 vote252 views1 answer
.net crash app
VBA
0 vote229 views1 answer
Convert unix to date vba
VBA
0 vote268 views1 answer
Excel vba protect content
VBA
0 vote216 views1 answer
Vba declare 64-bit ptrsafe
VBA