/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 vote217 views2 answers
Do until loop vba
VBA
0 vote214 views1 answer
Vb test if reference is null
VBA
2 votes230 views2 answers
Excel vba if sunday or staurday
VBA
3 votes212 views1 answer
Excel vba change format of cell
VBA
0 vote209 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote214 views1 answer
Xlbycolumns is not declared
VBA
0 vote237 views1 answer
Excel vba move down to next visible cell
VBA
0 vote233 views1 answer
Build an index all files of a FTP site
VBA
0 vote215 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote168 views1 answer
Vba set vs dim
VBA