/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

2 votes201 views1 answer
Date format for ms chart vb.net
VBA
0 vote198 views1 answer
Vb check if row has column
VBA
-1 vote215 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote204 views1 answer
.net dark title bar
VBA
0 vote209 views1 answer
How to use VBA to add new record in MS Access?
VBA
5 votes216 views1 answer
Xlvba double quotes in string literal
VBA
1 vote160 views1 answer
Ms access open form to new record
VBA
0 vote204 views1 answer
Vba shape transparent
VBA
0 vote230 views2 answers
Get unique random number in vb.net
VBA
0 vote220 views1 answer
Remove series name from legendvbnet
VBA