/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 vote152 views1 answer
Vba compare strings
VBA
0 vote173 views1 answer
Vbnet check if string is only numbers
VBA
0 vote161 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote159 views1 answer
Vbs expand env var
VBA
0 vote159 views1 answer
Excel run macro every 5 minutes
VBA
4 votes154 views2 answers
Excel vba last column with data
VBA
0 vote149 views1 answer
Get month number from month name vbnet
VBA
1 vote146 views2 answers
Get all column names from excel vba
VBA
5 votes183 views1 answer
Vba low word from Long Integer
VBA
0 vote150 views1 answer
Compare dates vb
VBA