/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 vote183 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote207 views1 answer
Excel vba calculate
VBA
1 vote196 views1 answer
Excel format cell as kilowatts
VBA
0 vote212 views1 answer
VBA Sleep Snippet
VBA
0 vote194 views1 answer
Vba shape transparent
VBA
32 votes272 views2 answers
Excel vba column letter
VBA
0 vote205 views1 answer
Excel vba StartUpPosition
VBA
0 vote202 views1 answer
Search in richtextbox vb.net
VBA
0 vote196 views1 answer
Vba code to select image in sheet
VBA
0 vote223 views1 answer
Vba integer to double
VBA