/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

4 votes245 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote248 views1 answer
Open file dialog in vb.net
VBA
0 vote230 views1 answer
Vb window.minimize
VBA
0 vote258 views1 answer
Vba parameter adodb null value
VBA
0 vote270 views1 answer
Style percent not found vba
VBA
0 vote238 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote233 views1 answer
Vba loop through table
VBA
31 votes310 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote248 views1 answer
Do while not vb.net
VBA
1 vote231 views1 answer
Close form vba
VBA