/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

8 votes186 views1 answer
Excel vba make integer
VBA
0 vote169 views1 answer
Vba loop through textboxes
VBA
0 vote155 views1 answer
Open application from vbnet
VBA
0 vote149 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote176 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote171 views1 answer
Excel vba automatic calculation
VBA
0 vote150 views1 answer
Remove frist letter from string vbnet
VBA
0 vote171 views1 answer
Vba find sub dictionary
VBA
0 vote163 views1 answer
Excel vba remove formatting from cell
VBA
3 votes166 views1 answer
Extract the nth word from a text string
VBA