/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 vote341 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote355 views2 answers
VB
VBA
1 vote361 views1 answer
Set font for ms chart vb.net
VBA
0 vote348 views1 answer
Vba table header name
VBA
0 vote377 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote364 views1 answer
Set datetimepicker value to null vb
VBA
0 vote313 views1 answer
Excel vba hide columns
VBA
0 vote342 views1 answer
Excel vba round to whole number
VBA
0 vote368 views1 answer
Excel vba add reference programmatically
VBA
0 vote325 views1 answer
Excel vba extract year
VBA