/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 views1 answer
Filesystemobject vba reference
VBA
4 votes172 views1 answer
Excel vba how to reset usedrange
VBA
0 vote176 views1 answer
Vba type
VBA
1 vote170 views1 answer
Excel vba last column in range
VBA
0 vote199 views1 answer
Build an index all files of a FTP site
VBA
0 vote204 views2 answers
Get unique random number in vb.net
VBA
1 vote164 views1 answer
Excel vba saveas force overwrite
VBA
1 vote194 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
5 votes186 views1 answer
Excel vba right word from Long Integer
VBA
0 vote163 views1 answer
Vba check 32 or 64 bit
VBA