/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 vote311 views1 answer
Ribbon show/hide
VBA
0 vote302 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote316 views1 answer
Excel vba round to whole number
VBA
0 vote333 views1 answer
Create links in msgbox in vb
VBA
0 vote314 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote308 views1 answer
Remove frist letter from string vbnet
VBA
0 vote301 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote432 views1 answer
Vba change active sheet
VBA
0 vote306 views1 answer
Vba len variant
VBA
1 vote313 views1 answer
Vbs run
VBA