/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

5 votes144 views1 answer
Excel vba left word from Long Integer
VBA
0 vote142 views1 answer
Move bindingnavigator vb
VBA
22 votes275 views1 answer
Xl vba check for folder
VBA
0 vote144 views1 answer
Vba loop through textboxes
VBA
0 vote131 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote134 views1 answer
Vba border weight
VBA
0 vote138 views1 answer
Vba string start with
VBA
0 vote131 views1 answer
How to format a textbox as date vb net
VBA
0 vote154 views1 answer
Vba table header name
VBA
0 vote190 views1 answer
Excel vba protect content
VBA