/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 vote368 views2 answers
Vba function return array
VBA
0 vote352 views1 answer
Vb run command
VBA
1 vote379 views1 answer
Excel vba to lower case
VBA
2 votes342 views1 answer
Vba uppercase first letter of each word
VBA
0 vote390 views1 answer
Vba parameter adodb null value
VBA
0 vote378 views1 answer
Excel vba protect sheet
VBA
0 vote365 views1 answer
Vba shape transparent
VBA
2 votes366 views2 answers
Excel vba copy values range to another range
VBA
0 vote385 views1 answer
Vba random number
VBA
-1 vote359 views1 answer
How to correct a number to 2 decimal places in vba
VBA