/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

2 votes160 views2 answers
Excel vba copy values range to another range
VBA
0 vote162 views1 answer
Vba declare 64-bit ptrsafe
VBA
1 vote159 views1 answer
Excel vba to lower case
VBA
0 vote152 views1 answer
Afficher un message d'erreur vba
VBA
0 vote165 views1 answer
Vba range clear formatting
VBA
0 vote116 views1 answer
Vbide vbproject reference
VBA
0 vote172 views2 answers
Excel vba protect cells with formula
VBA
0 vote171 views1 answer
Vbnet click on dgv cells
VBA
0 vote174 views1 answer
Vbscript Trim
VBA
0 vote191 views1 answer
Wpf dark title bar
VBA