/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

8 votes148 views1 answer
Run command pormpt in background windows
VBA
0 vote123 views1 answer
Vb window.minimize
VBA
1 vote132 views1 answer
Excel vba array remove first
VBA
0 vote139 views1 answer
Date as number vb
VBA
1 vote72 views1 answer
Ms access open form to new record
VBA
0 vote134 views2 answers
Do until loop vba
VBA
0 vote128 views1 answer
Vbs write file
VBA
0 vote128 views2 answers
Excel vba number format file size
VBA
0 vote146 views1 answer
Excel vba move down to next visible cell
VBA
0 vote124 views1 answer
Visual basic msdos
VBA