/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 vote189 views4 answers
Jwt token vb.net validation
VBA
1 vote185 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote180 views1 answer
Vba add shape oval
VBA
-1 vote178 views1 answer
Vba code to add new column in table
VBA
0 vote200 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote202 views1 answer
Vbnet check if string is only letters
VBA
0 vote180 views1 answer
Vba extract filename from path
VBA
0 vote179 views1 answer
Vba get workbook name
VBA
0 vote180 views1 answer
Add text to combobox drop down vb
VBA
0 vote196 views2 answers
VB
VBA