/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 vote223 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote243 views1 answer
Vba random number
VBA
0 vote229 views2 answers
Do until loop vba
VBA
0 vote226 views1 answer
Visual basic msdos
VBA
1 vote225 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote230 views1 answer
Vba min
VBA
0 vote250 views1 answer
Excel vba urlmon
VBA
22 votes535 views1 answer
Xl vba check for folder
VBA
0 vote210 views1 answer
Open application from vbnet
VBA
0 vote229 views1 answer
Dlete rows with blanks and space " " vba
VBA