/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 vote244 views1 answer
Add rows to datagridview vb.net
VBA
2 votes242 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote242 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote289 views1 answer
Winforms dark title bar
VBA
1 vote183 views1 answer
Ms access open form to new record
VBA
0 vote242 views1 answer
Set column width of datagridview vb.net
VBA
0 vote271 views1 answer
Get month number from month name vbnet
VBA
0 vote236 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
5 votes259 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote314 views1 answer
Find control with name vb
VBA