/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 vote179 views1 answer
Refresh token em vb net
VBA
1 vote194 views1 answer
Change the first item in a queue vb.net
VBA
0 vote188 views1 answer
Vba copy file
VBA
0 vote199 views1 answer
Vba sort the data Z to A
VBA
0 vote176 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote184 views1 answer
Excel vba protect content
VBA
1 vote180 views1 answer
Vba optional
VBA
0 vote181 views1 answer
VBA Loop to range
VBA
4 votes191 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote196 views1 answer
Vbnet convert charatcer to binary
VBA