/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 vote190 views1 answer
Perform http request in vb.net
VBA
4 votes180 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote160 views1 answer
Vba code to open a file with login rights
VBA
2 votes164 views1 answer
Excel vba extract file name
VBA
1 vote178 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote179 views1 answer
VBA Sort RossetaCode
VBA
0 vote169 views1 answer
Telephon call in vba
VBA
0 vote158 views2 answers
Excel vba copy paste after last row
VBA
3 votes206 views2 answers
Vba date to string
VBA
0 vote163 views1 answer
Excel vba formatconditions positive
VBA