/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 vote248 views1 answer
Excel vba protect shapes
VBA
0 vote245 views1 answer
Excel vba select multiple shapes
VBA
0 vote240 views1 answer
How to carry text to the next line in a label in vb.net
VBA
5 votes237 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote240 views1 answer
Openfiledialog specific folder
VBA
1 vote254 views1 answer
Excel vba to lower case
VBA
0 vote233 views1 answer
Vbs expand env var
VBA
0 vote226 views1 answer
Vba option button selected
VBA
0 vote237 views1 answer
VBA is form loaded
VBA
0 vote241 views1 answer
Vbnet hex to binary
VBA